Search filter for empty text?


(Richard PALO) #1

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.


(Cédric Krier) #2

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: =.


(Richard PALO) #3

Yes… that does it.
Cheers


(system) #4

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