Using wildcard operators when querying a database

Question

Hello, I was searching through documentation but I cannot seem to find anything pertaining to this. Is it possible within Appian to query a database in a way that would be similar to the following SQL Query? Select * from Table where tableID = tableID2 Basically I am trying to return rows where one column equals another column. Thanks! 
 OriginalPostID-150044 
 OriginalPostID-150044

sikhivahans · Accepted Answer

@issamd AFAIK I don't think it's doable as of now. Probably an indirect way of doing it can be as follows:

with(
local!arrayOfField2Values:rule!getField2Values(),
a!queryFilter(
field: "field1",
operator: "in",
value: local!arrayOfField2Values
)
)

An other alternative is to have a look at https://forum.appian.com/suite/tempo/records/type/components/item/i8BWsQdLlzKy55h8z8zJ0sPqpDWFrba_btZb9XmhOR1BKg7QGGvFF6eh5hlLPpeuA/view/summary which would help you make joins between data.

Tyler Criste · Answer

It does look like the CDT manipulation plug-in could work. You could query twice for the entire table, then join the two data sets on set1.field1 = set2.field2. Depending on the size of the table, there could be performance issues with pulling in the full data set into process.