Using advanced search, I'm trying to exclude lines from displayed results.
When I set "XXX" in a text column filter, dbFront returns lines containing "XXX" ("XXX%" will return lines starting with "XXX" by the way, good to know !)
Now I'm trying to display lines not containing "XXX".
Is there a syntax or a trick to achieve that ?
If there isn't, it could be great to have a checkbox to "invert" the SQL condition.
I'm thinking to wrapping the SQL criteria in "NOT (...)".
- If not activated, SQL will remain : ... WHERE COLUMN_NAME LIKE '%XXX%' ...
- If activated, SQL will become : ... WHERE NOT ( COLUMN_NAME LIKE '%XXX%' ) ...