Feature proposal #9479: Implement support for empty and not empty advanced table searching - CB - Joomlapolis forge

Actions

Copy link

Feature proposal #9479

closed

Implement support for empty and not empty advanced table searching

Added by krileon 12 months ago. Updated 11 months ago.

Status:

Closed

Priority:

Low

Assignee:

krileon

Target version:

CB 2.9.3

Start date:

19 August 2024

Due date:

% Done:

100%

Estimated time:

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.

Actions

Copy link

Updated by krileon 12 months ago

https://www.joomlapolis.com/forum/general/246272-is-it-possible-add-more-operator-to-user-managment-search?start=6#338939

Actions

Copy link

Updated by krileon 12 months ago

This is due to isValueEmpty check on the _filterPossibilitesArray in the TableBrowser handler. This probably needs to be ignored for specific filters.

Actions

Copy link

Updated by krileon 12 months ago

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)