Project

General

Profile

Actions
Copy link

Bug #4883

closed

Userlist basic filter <> empty string not handling null

Added by krileon almost 10 years ago. Updated almost 10 years ago.

Status:
Closed
Priority:
Normal
Assignee:
krileon
Target version:
CB 2.0.4
Start date:
24 November 2014
Due date:
% Done:

100%

Estimated time:

Description

When you've a <> (empty string) basic filter it's doing c.`FIELD_NAME` <> ''. It needs to also add AND c.`FIELD_NAME` IS NOT NULL to account for proper empty value checking.

https://www.joomlapolis.com/forum/153-professional-member-support/226285-solved-list-filters-and-empty-or-null-fields?start=24#253344

Actions
Copy link

Also available in: Atom PDF