In QueryEntity, we are using nested condition to get the desired data from the D

Karthik over 8 years ago

In QueryEntity, we are using nested condition to get the desired data from the DB Table. However, we are getting "Expression evaluation error at function a!queryEntity: Cannot apply a filter with a blank field name." exception during execution. Without the nested condition the query works fine and when we introduce nested condition, we are getting the mentioned error. We couldnt figureout what went wrong. Any help is appreciated. Please find the queryEntity rule attached for reference

QueryEntity.txt

Discussion posts and replies are publicly visible

Top Replies

Sidhant Behura over 8 years ago +1

@karthikeyans75 - There is a small syntactical error. In the a!queryLogicalExpression, you have "filters" and inside that you have included "logicalExpressions" which is not correct. Both should be separate…

Parents

0 Sidhant Behura over 8 years ago

@karthikeyans75 - No problem ... Happy to help...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 auxeeliyaj0001 over 5 years ago in reply to Sidhant Behura

i'm new to Appian. I have an issue with expression rule. my rule is as follows:

a!queryEntity(
entity: cons!LCW_BUSINESS_UNIT_ENTITY,
query: a!query(
filter: if(
rule!APN_isEmpty(ri!businessDivision.id),
{},
a!queryFilter(
field: "businessDivision.id",
operator: "=",
value: ri!businessDivision.id)
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1,
sort: a!sortInfo(
field: "order",
ascending: true
)
)
),
fetchTotalCount: true
)

but when i execute this i get the following error

Expression evaluation error at function a!queryEntity: Cannot apply a filter with a blank field name.

can you pls help?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 auxeeliyaj0001 over 5 years ago in reply to Sidhant Behura

i'm new to Appian. I have an issue with expression rule. my rule is as follows:

a!queryEntity(
entity: cons!LCW_BUSINESS_UNIT_ENTITY,
query: a!query(
filter: if(
rule!APN_isEmpty(ri!businessDivision.id),
{},
a!queryFilter(
field: "businessDivision.id",
operator: "=",
value: ri!businessDivision.id)
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1,
sort: a!sortInfo(
field: "order",
ascending: true
)
)
),
fetchTotalCount: true
)

but when i execute this i get the following error

Expression evaluation error at function a!queryEntity: Cannot apply a filter with a blank field name.

can you pls help?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data