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: "")
Discussion posts and replies are publicly visible
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) --
Thank you. The combination you mentioned worked. Also the below works.
a!queryFilter( field: "x", operator: "<>", value: " " )
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.