wish: ledger quicksearch match multiple terms with OR/AND

[TonyIT]

Hi Maxime

It's possible to modify the behaviour of the filter in the ledger in order to search with the AND condition?

Imagine to have "A B C" and "A C B", if you need to search both of this strings you have to write the exact sequence of the chars.
With an AND condition, instead, the search will be much easier: ["A" [space] "B"] will be translate in
'SELECT * FROM the-ledger WHERE almost-every-field LIKE "*A*" AND almost-every-field LIKE "*B*"'

If someone disagree, a choice in the preference can do the trick:
    [X] in the ledger, filter with an AND condition

That would make the job a lot easier.

Grazie e ciao.
TonyIT

[Maxime DOYEN (mdoyen)]

after a little study on how others do this, I decided to think to the gmail behaviour

Search for an exact word or phrase with " " (which is the actual behaviour in HB)
=> "dinner tonight"
=> will only match this exact phrase

What you want is to enable OR for multiple words
Search match multiple terms with OR
=> "amy OR david"
=> will match any txn that match amy or david

source: https://support.google.com/mail/answer/7190?hl=en

[TonyIT (nc8430)]

I got your point but you missed the AND I'm searching for.

some example:
"uno due tre"
"uno tre due"
"due tre uno"
"uno tre quattro"
"uno quattro tre"

I need to search only the records containing the words "uno" and the word "quattro", so:

=> uno OR quattro > all the records [NOT what I wish]
=> "uno quattro" > only the last
=> uno AND quattro > the last two [That's Sound Good!] <= <=

Grazie mille.
Tony

[Maxime DOYEN (mdoyen)]

no one else seem to need this so I close.