• State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 15 replies
  • Subscribers 7 subscribers
  • Views 4907 views
  • Users 0 members are here
Related Discussions
Home » Discussions » AI and Rules

Using wildcard operators when querying a database

issamd

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

  Discussion posts and replies are publicly visible

Parents
  • 0
    Appian Employee
    Regarding the suggestion of using the "in operator", I'm not sure that would work. The initial query (to return array of field 2 values) would return all field 2 values. And you just want rows where that row's value for field 1 = that row's value for field 2, correct? The "in" logic would return all rows where field 1 = ANY value found in column 2, rather than where field 1 = that same row's field 2.
Reply
  • 0
    Appian Employee
    Regarding the suggestion of using the "in operator", I'm not sure that would work. The initial query (to return array of field 2 values) would return all field 2 values. And you just want rows where that row's value for field 1 = that row's value for field 2, correct? The "in" logic would return all rows where field 1 = ANY value found in column 2, rather than where field 1 = that same row's field 2.
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.