Searching for Null values via standard query panel Range tab (AX V4)

Can anyone tell me what phrase I should use to retrieve records based on a field being empty. eg. I have tried:

(valueEmpty String())

and serveral variants therof with no success.

Does anyone know how do define a search for a given field with a value of blanks?



In code, use SysQuery::valueEmptyString(). In GUI, use “”. (I suppose it’s a text field.)

Also don’t confuse an empty string with NULL (as in the title of this thread). These are two different values in DB (nevertheless AX doesn’t support NULL values).

Thanks Martin - I was trying to select for blank field values in an AX V4 Grid Filter, so the GUI solution worked fine. Thanks again!