Database and filters in Bartender Follow

0
Avatar
Leen Van Brandt

Dear Community,

 

Something very strange happened.

I was using the filter in Bartender filtering on empty cells for a certain database field: 'field is null'.

Earlier today it was still there, but suddenly this option is now not available anymore... The field is "Value_txt_1".

The filter automatically changed to "field is between .. and ..."

 

Can anyone help me?

1 comments

0
Avatar
Al Perez
Moderator
Comment actions Permalink

Hi Leen,

Thank you for your post! If you're trying to filter by null, you'll have to use the 'is null' operator; you cannot use it in the value field since null has no value (you might have experienced a visual bug if you did see this). Also, keep in mind that the null-based operators are only available if your database's field data-type allows for null to be used (check your database to make sure this is true). See my example:

If you want to search a range and also include records with null, you'll want to make sure that both conditions are in the statement.

 

Cheers,

Al

 

Please sign in to leave a comment.