[FAQ000018] What is the difference between searching for all items and not searching for all items in the case of blank string in the table search condition?

Q

Some of the table’s search condition searches for all items when it is empty string, while others do not.

What is the difference?

A

When value as the search condition is an empty string, and any one of the following conditions is used: 'does not match', 'includes', 'starts with', 'ends with', 'is not smaller than', 'is larger than', or 'not matches any of the following', all records where the column’s value is not empty will be searched.

On the other hand, when any one of the following conditions is used: 'matches', 'not includes', 'not starts with', 'not ends with', 'is not larger than', 'is smaller than', or 'matches one of the following', no data is retrieved.

And, it is possible to exclude such conditions at the time of action execution. For more information, see Exclude condition if search condition is empty.