Hi All, I have created a query Entity that fetches data from a view.

Hi All,

I have created a query Entity that fetches data from a view. I am facing issue when the query entity has blank inputs & it tries to fetch all the values. How can I make sure to return no values when the input is null. Below s the query entity code:

= a!queryEntity(
entity: cons!LISTING,
query: a!query(
logicalExpression: if(
and(
rule!APN_isBlank(
ri!Num
),
rule!APN_isBlank(
ri!secondID
),
rule!APN_isBlank(
ri!Code
),
rule!APN_isBlank(
ri!D
)
),
null,
a!queryLogicalExpression(
operator: "AND",
filters: {
if(
rule!APN_isBlank(
ri!Num
),
{},
a!queryFilter(
field: "Num",
operator: "=",
value: ri!Num
)
),
if(
rule!APN_isBlank(...

OriginalPostID-208504

OriginalPostID-208504