Advanced filter Note always generates zero results on partial text

Vista, 7, 8, 8.1. Unicode builds: x86, x64, ia64 versions available.

Moderator: Renato

stefanopid
New MMEX User
Posts: 7
Joined: Mon May 04, 2020 11:53 am
Are you a spam bot?: No

Advanced filter Note always generates zero results on partial text

Post by stefanopid »

Hello,
I have been using the 1.3.5 version on Windows 10 and noticed a behavior that, as far as I remember, should not be correct.
Basically, when you are on a bank account and want to filter some transactions on "Advanced filter" and specifying some text in the Note field you will always get zero results unless you write the exact note of a certain transaction. I remember that in previous versions I could just write a word on "Note" field and the search gave me all transactions whose note contains that word, not the exact sentence.

Could you please check and fix this?

Thanks

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Advanced filter Note always generates zero results on partial text

Post by Renato »

Use "Note*"
regards Renato use MMEX since 2009

stefanopid
New MMEX User
Posts: 7
Joined: Mon May 04, 2020 11:53 am
Are you a spam bot?: No

Re: Advanced filter Note always generates zero results on partial text

Post by stefanopid »

I wrote that I use "Note", but it only works if I put the EXACT sentence, whilst it does not work if I only put a word that is contained in a sentence. Example of a note "This is xyz transaction". The search produces zero results if I just write, for example, "xyz" in the "Note" field of the "Advanced Filter". I remember that that in previous version than 1.3.5 this kind of search worked.

stefanopid
New MMEX User
Posts: 7
Joined: Mon May 04, 2020 11:53 am
Are you a spam bot?: No

Re: Advanced filter Note always generates zero results on partial text

Post by stefanopid »

Ah ok, thanks. So I just checked that using *note* I get all results that contain "note".

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Advanced filter Note always generates zero results on partial text

Post by Renato »

Use "*xyz*" :idea:
regards Renato use MMEX since 2009

stefanopid
New MMEX User
Posts: 7
Joined: Mon May 04, 2020 11:53 am
Are you a spam bot?: No

Re: Advanced filter Note always generates zero results on partial text

Post by stefanopid »

Thanks :)

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Advanced filter Note always generates zero results on partial text

Post by Renato »

Wikipedia

Probably this will also work with MMEX with these specifications.

Many command line interpreters and other programs allow the use of such placeholders, for example to address groups of files with similar names. Also search functions in text editors know such placeholders. Furthermore, search engines such as Google or website search functions such as Wikipedia work with them.

Frequently used placeholders are:

the question mark (?) for exactly one character
the underscore (_) for exactly one character
the asterisk (*) for any number (even zero) of characters
the percent sign (%) for any number of characters (including zero)
the double cross (#) for a numeric value.


A search for ?off finds all strings ending on off and preceded by any character; examples would be house, house, mouse and out. The search for *out, on the other hand, also returns approximately out and out.
regards Renato use MMEX since 2009

Nikolay
MMEX Developer
Posts: 1384
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Advanced filter Note always generates zero results on partial text

Post by Nikolay »

For search text sctring mmex is using Match function.


bool wxString::Matches (const wxString & mask) const

Returns true if the string contents matches a mask containing '*' and '?'.

https://docs.wxwidgets.org/3.0/classwx_ ... 1f29a84e20

User avatar
Renato
MVP MMEX User
Posts: 195
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich
Contact:

Re: Advanced filter Note always generates zero results on partial text

Post by Renato »

Hello Nikolay
Thank you for the technical explanation of the search, but I'm having trouble understanding it.

But I have tested the "advanced filter" in the "Account View:" and found out that it does not work.
The entries are not accepted, the saved value 9 is evaluated.
regards Renato use MMEX since 2009

dbolton
MVP MMEX User
Posts: 43
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No

Re: Advanced filter Note always generates zero results on partial text

Post by dbolton »

I also found the Advanced filter Note isn't working as expected. As a workaround, the Search at the bottom of the transaction window can be used to find matches. I noticed the search at the bottom finds matches above the currently selected transaction, so start at the bottom.

Post Reply