Using nested logical expressions while using a!queryEntity in SAIL

jaishankarj over 8 years ago

I need to execute nested logical expressions while using a!queryEntity in SAIL for one of the report. I tried many options but getting multiple errors for duplicate Indices or duplicate keywords. Has anyone used nested logical expression and if yes could you please share the sample to refer. The scenario is: I want to do a OR check on two set of data which has AND conditions in their WHERE Clause [(AND) OR (AND)]

Discussion posts and replies are publicly visible

0 sikhivahans over 8 years ago

@jaishankarj Just in case, if you haven't gone through the documentation, I would like to suggest you to refer the content at https://forum.appian.com/suite/help/16.1/Query_Recipes.html#Querying_on_Nested_Conditions.

If you are facing any problem even after being aware of the above mentioned content, do let us know re what and how you have done by attaching the code snippet at a high level and then the practitioners here can help you.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Chris over 8 years ago

Yes, I've used nested logicalExpressions to 3 or 4 levels with success. I will attach an example here with queryEntity used in a service backed record, 3 levels of nested logicalExpressions as: AND(facets,AND(OR(filters),OR(filters),OR(filters)))
SIR_gerRecordData.SAIL
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sikhivahans over 8 years ago

@jaishankarj Added to what has been specified above, if you haven't gone through the syntax of a!queryLogicalExpression(), I would like to suggest you to do so by going through the content at https://forum.appian.com/suite/help/16.1/System_Functions.html#a!queryLogicalExpression.28.29, because nesting is nothing but configuring the 'logicalExpressions' argument of a!queryLogicalExpression() with an array of LogicalExpression objects.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel