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

Notice line no 32, it seems you missed to pass value parameter to queryFilter.

@mohanp If you are talking about the 'id' filter in the code snippet, just to let you know, the 'value' parameter is optional when 'not null' is applied as filter(Reference: https://forum.appian.com/suite/help/16.1/Appian_Data_Types.html#QueryFilter). So that may not be a issue at all.

Ahh Thanks Sikhivahan. I missed that.

@karthikeyans Hi, I have refactored your code slightly(as per my knowledge, I felt the need of doing so) and it would be worth testing the attached code snippet and letting us know if there are any issues still.

QueryEntity_Modified.txt

@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.

@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.

@mohanp, I added naics col too, it didnt work. The same query works fine when I take off the nested condition

@sikhivahans, thanks for the refactoring. The new code gives the same error too

@Karthikeyan Hi,
I have updated your code slightly and attached, Try with this code and let me know if there are any issues,

QueryEntity_Updated.txt

@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.