How do you form an ".in." clause?

CloverDX Platform
1

Hi,

I can’t find in the documentation an example of an “.in.” statement. I want to use an ExtFilter with filters out data. I’m looking for various codes:

152W00000X
156FX1800X
156FX1201X
156FX1202X
…

Would someone kindly post an example of an .in. clause?

I only want records that match the code. Maybe there is a better mechanism than an .in. clause??

thanks
Jay

2

Hello Jay,
.in. operator serves to specify whether some value is contained in the list or in the map of other values, eg.:


int value = 7;
boolean is_in_list;
is_in_list= value .in. [1, 2, 3 ,10, 50, 60];

To find if some value matches a pattern you have to use regular expressions. Eg. to filter values, that contain “120” on position 6, you need to use filter expression like:


$0.my_value ~= '\d{3}\w.120\dX'

(See Pattern for regular-expression constructs)

3

ah ha,

Thanks:
$0.HC_PROV_Taxonomy_Code_1 .in. [“152W00000X”, “156FX1800X”]

Works like you described. I couldn’t find any example how to form the list. I was using ( ) instead of

Thanks
Jay