How to exclude rows which has empty string in one field from a!queryentity result

Question

I have a table in DB. Which has column called x which is of varchar type(255). I am fetching records in Appian using a!queryentity function. I just want to exclude records which are having "" mapped for column x. I tried like below which are not working. Still its fetching the rows which are having empty string mapped for the column. Can someone help? 
 
 a!queryFilter(field: "x", operator: "not null"), 
 a!queryFilter( field: "x", operator: "not in", value: "" ) 
 a!queryFilter( field: " x ", operator: "<>", value: "" )

Mike Schmitt · Accepted Answer

The combination I typically find works is "not in" and {""} (that is, an array of an empty string). 
 Here's an example (but in reverse) --

Mike Schmitt · Answer

As a caution, if your DB has a mixture of "empty string" and "true null" values for this field, then you should use a LogicalExpression to filter against both conditions.

How to exclude rows which has empty string in one field from a!queryentity result

Top Replies