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 sikhivahans over 8 years ago

@pavang If you meant to say that a column should be queried in order to apply filter on it, just to let you know, to the best of my knowledge, that's not correct. You can still apply the filter on a column though it's not retrieved. (Reference: https://forum.appian.com/suite/help/16.1/Query_Recipes.html#Retrieve_the_Data_for_a_Single_Field. The 'id' column isn't being retrieved, yet it's used as filter.)

In short, there isn't a need to retrieve 'naics' just because of the reason that a filter is applied on it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 8 years ago

@pavang If you meant to say that a column should be queried in order to apply filter on it, just to let you know, to the best of my knowledge, that's not correct. You can still apply the filter on a column though it's not retrieved. (Reference: https://forum.appian.com/suite/help/16.1/Query_Recipes.html#Retrieve_the_Data_for_a_Single_Field. The 'id' column isn't being retrieved, yet it's used as filter.)

In short, there isn't a need to retrieve 'naics' just because of the reason that a filter is applied on it.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data