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.