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 - 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. Please refer the updated code snippet.

Please refer the link below link for more information.
https://forum.appian.com/suite/help/16.1/System_Functions.html#a!queryLogicalExpression.28.29

Hope the information is helpful.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 samarm0001
Certified Associate Developer
over 1 year ago in reply to Sidhant Behura

Thanks, it helped.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 samarm0001
Certified Associate Developer
over 1 year ago in reply to Sidhant Behura

Thanks, it helped.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data