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

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

OriginalPostID-211996

OriginalPostID-211996

  Discussion posts and replies are publicly visible

Parents
  • @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.
Reply
  • @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.
Children