Here is an example of how to query for Null values in 4D with the QUERY BY FORMULA command:

QUERY BY FORMULA([Table_1];Is field value Null([Table_1]Field_id))

In the example above, the selection for [Table_1] will include only records that have a null value in Field_id.