Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
+1
person also asked this
people also asked this
Replies
16 replies
Subscribers
8 subscribers
Views
12348 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
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
OriginalPostID-211996
OriginalPostID-211996
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
Pavan
over 8 years ago
@mohanp In addition to the above comments in the attached snippet code, you are applying the filter based on one column named "naics", but you are not querying the that column. Try to query that required one and check it. Hope it will work.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Pavan
over 8 years ago
@mohanp In addition to the above comments in the attached snippet code, you are applying the filter based on one column named "naics", but you are not querying the that column. Try to query that required one and check it. Hope it will work.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data