This change adds the ability to search for null values from a dataTables search string.
For example, say there are 3 possible values for a column: Sent, Received, Unknown, yet it is a nullable column. To find Sent and Unknown rows the filter is Sent+Unknown. However, NULL could be interpreted as Unknown too.
With this modification you can specify Sent+Unknown+NULL to see rows with null values. In order to look for the text NULL, escape the value as \NULL.
Changes:
Added a constants for NULL and escaped NULL.
Added code to look for NULL in the list of values and remove it
Added code to look for NULL in a list of boolean tests
Added code to add “column IS NULL” when necessary
Added code to look for NULL as a single value and handle appropriately
Added unit tests to cover all the paths and options
darrachequesne
commented
7 years ago
This change adds the ability to search for null values from a dataTables search string.
For example, say there are 3 possible values for a column:
Sent, Received, Unknown, yet it is a nullable column. To findSentandUnknownrows the filter isSent+Unknown. However, NULL could be interpreted asUnknowntoo.With this modification you can specify
Sent+Unknown+NULLto see rows with null values. In order to look for the textNULL, escape the value as\NULL.Changes:
Added a constants for NULL and escaped NULL. Added code to look for NULL in the list of values and remove it Added code to look for NULL in a list of boolean tests Added code to add “column IS NULL” when necessary Added code to look for NULL as a single value and handle appropriately Added unit tests to cover all the paths and options