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