Page 1 of 2

Advanced filter Note always generates zero results on partial text

Posted: Wed Sep 30, 2020 7:30 pm
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

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

Posted: Wed Sep 30, 2020 7:40 pm
by Renato
Use "Note*"

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

Posted: Wed Sep 30, 2020 7:54 pm
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.

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

Posted: Wed Sep 30, 2020 8:02 pm
by stefanopid
Ah ok, thanks. So I just checked that using *note* I get all results that contain "note".

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

Posted: Wed Sep 30, 2020 8:11 pm
by Renato
Use "*xyz*" :idea:

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

Posted: Wed Sep 30, 2020 8:16 pm
by stefanopid
Thanks :)

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

Posted: Wed Sep 30, 2020 8:36 pm
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.

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

Posted: Wed Sep 30, 2020 8:58 pm
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

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

Posted: Fri Oct 02, 2020 6:37 pm
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.

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

Posted: Wed Oct 07, 2020 4:05 am
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.