Feature proposal #9479
closed
Implement support for empty and not empty advanced table searching
Added by krileon 3 months ago.
Updated 3 months ago.
Start date:
19 August 2024
Description
Queries with empty values (e.g. not equal to EMPTY) should be a ( `column` IS NOT NULL AND `column` != '' ) query, but appears the filter is entirely skipped if no value is supplied.
Instead of modifying equal to and not equal to implement explicit is empty and is not empty operators.
This is due to isValueEmpty check on the _filterPossibilitesArray in the TableBrowser handler. This probably needs to be ignored for specific filters.
- Tracker changed from Bug to Feature proposal
- Subject changed from User management field filters with empty values results in no query to Implement support for empty and not empty advanced table searching
- Description updated (diff)
- Status changed from Assigned to Resolved
- % Done changed from 0 to 100
- Status changed from Resolved to Closed
Also available in: Atom
PDF
Updated by 
Updated by