Search filter for empty text?

I’d like to be able, for example, do a search filter to select all accounting move lines that have Description empty (null) as selected from the open chart of accounts for a particular account.

What is the syntax to filter on a null string? ‘Description: “”’ doesn’t seem to do it.

The value representing Null/None is nothing. But as the default operator for Char field is ilike which does not allow None, the equal operator must be specified. So the search syntax is: Description: =.

1 Like

Yes… that does it.

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.