Skip to main content
R
radhamanir1935
March 6, 2026
Solved

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

  • March 6, 2026
  • 3 replies
  • 0 views

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: ""
)

Best answer by mikes0011

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) --

3 replies

mikes0011
mikes0011Answer
Brainy
March 6, 2026

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) --

    R
    radhamanir1935Author
    March 6, 2026

    Thank you. The combination you mentioned worked. Also the below works.

    a!queryFilter(
    field: "x",
    operator: "<>",
    value: " "
    )

    Terms & ConditionsAccessibility statement