Project

General

Profile

Actions
Copy link

Feature proposal #9479

closed

Implement support for empty and not empty advanced table searching

Added by krileon 3 months ago. Updated 3 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
 #2

Updated by krileon 3 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
 #3

Updated by krileon 3 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)
Actions
Copy link
 #4

Updated by krileon 3 months ago

  • Status changed from Assigned to Resolved
  • % Done changed from 0 to 100

Implemented in MR !1956

Actions
Copy link
 #5

Updated by beat 3 months ago

  • Status changed from Resolved to Closed
Actions
Copy link

Also available in: Atom PDF