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

rishub356 over 8 years ago

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(...

Discussion posts and replies are publicly visible

Parents

0 rishub356 over 8 years ago

...
ri!Code
),
{},
a!queryFilter(
field: "Code",
operator: "=",
value: ri!Code
)
),
if(
rule!APN_isBlank(
ri!secondID
),
{},
a!queryFilter(
field: "secondID",
operator: "=",
value: ri!secondID
)
),
if(
rule!APN_isBlank(
ri!ID
),
{},
a!queryFilter(
field: "ID",
operator: "=",
value: ri!ID
)
),
a!queryFilter(
field: "parentID",
operator: "is null"
)
}
)
),
pagingInfo: rule!PDIM_genericPagingInfo_All()
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 rishub356 over 8 years ago

...
ri!Code
),
{},
a!queryFilter(
field: "Code",
operator: "=",
value: ri!Code
)
),
if(
rule!APN_isBlank(
ri!secondID
),
{},
a!queryFilter(
field: "secondID",
operator: "=",
value: ri!secondID
)
),
if(
rule!APN_isBlank(
ri!ID
),
{},
a!queryFilter(
field: "ID",
operator: "=",
value: ri!ID
)
),
a!queryFilter(
field: "parentID",
operator: "is null"
)
}
)
),
pagingInfo: rule!PDIM_genericPagingInfo_All()
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data