Designer - In-DB Custom Filter using multiple 'IN' & 'OR' conditions

[Brian_Foody]

The following custom filter statement is omitting results from 'ultimate_parent_id' & ''legal_entity_id' columns I expect to see when I run the workflow(i.e. these numbers are in my data set) 

Can the syntax be changed to make this work or other solution I can try ?

(  organization_id IN (10002456, 345678)

OR ultimate_parent_id IN (543290, 56704)

OR legal_entity_id IN (114320, 657890)   )

Thanks

[atcodedog05]

Hi @Brian_Foody 

Can you provide some sample input and expected output it will help us get a better understanding of the usecase.

[Garabujo7 · Accepted solution]

Hello @Brian_Foody ,

It will be helpful if you provide some data as Arturo said.

Here is the Alteryx sintax for that filter:

Gabriel

[terry10]

Your custom filter is equivalent to:

IF organization_id = 10002456
OR organization_id = 345678
OR ultimate_parent_id = 543290
OR ultimate_parent_id =56704
OR legal_entity_id = 114320
OR legal_entity_id = 657890
THEN 'True'
ELSE 'False'
ENDIF

So, if any of these 6 conditions is True the record will flow out the T anchor.

The F anchor output will only have records in which all of these 6 conditions are False.

What is your desired output?

[apathetichell]

in (in alteryx at least) is a string term. Those are numbers. the proper format for alteryx would be in organization_id IN ('10002456', '345678')

[Brian_Foody]

Thanks All -it turned out to simply be an issue with the browse tool not loading the records I searched for and expected to see. When I looked them up using a filter tool I could see the were passed through correctly using my original syntax. Appreciate the replies