Is there a way to construct a Logic Block Expression that works like an IN operator in SQL?

No-Code Platform
1

I am looking thru the Online Help to see if there is a way to construct a logic block expression that would work like an IN operator in SQL. For example, I want to fetch Directory records if the nwId is IN a list of nwId.

2

I see there is Build Dynamic Expression action that I might be able to use. Basically,

  1. start with a new empty Build Dynamic Expression as DynamicExpression
  2. loop thru a list of records (FetchRecord) and
    1. update the Build Dynamic Expression DynamicExpression with
      1. (SomeTable.nwId equals FetchRecord’s nwId) or DynamicExpression

So basically, it is effectively doing A or B or C or D …, where each condition is SomeTable.nwId = FetchRecord.nwId.

Is there a more efficient way, especially if the list could have a hundred values?

1 Like
3

Using Build Dynamic Expression the way you outline is the only way I can think of to do this.