Hi All,
Here is my query.
I have DB TABLE with column A, column B, column C.
Please help me to convert below SQL query in to Appian Query Entity.
Select * from TABLE where column A = column B;
DSE Constant : cons!TEST_DSE_TABLE
CDT fields are : columnsA,columnB,columnsC
Thanks in Advance.
Discussion posts and replies are publicly visible
Appian does not directly support this kind of queries. Either create a view in DB or use synchronized records and a custom record field that stores the result of this comparison.
In the query entity function, you can use logical expressions and filters in query parameter. Please do refer this link: a!queryEntity() Function - Appian 23.1
But you cannot compare two fields in DB to each other. This is what the TO was asking for.