Construct a string to select multiple values by "Select In Field" action

[vlad_komarov]

Hello!

I need to select multiple values in a field using "Select In Field" action. I need to find a way to construct a string for that purpose using a proper values separator.

It works perfectly for single selection: (select the value in ACCOUNT_TYPE field based on the selection in ACCOUNT_TYPE_ABBREV field😞

[Select In Field]  -->  Field=ACCOUNT_TYPE --> Search String =GetFieldSelections(ACCOUNT_TYPE_ABBREV, '!')

I've tried multiple values separators (the second parameter in GetFieldSelections() function above), but without much success.

I would appreciate any suggestion.

Best regards,

Vladimir

[swuehl]

The Search String

[maxgro · Accepted solution]

define a variable v

='(' &

concat('"' & ACCOUNT_TYPE_ABBREV & '"', '|')

& ')'

select in field

='$(v)'

[vlad_komarov]

Swuehl,

I've tried that '(AAA|BBB)' option, does not work directly.

But Massimo's suggestion (below) seems to be working in my case.

Thanks!

VK

[vlad_komarov]

Massimo,

Thanks, it seems to be working in my case.

The only concern will be a performance issue (using "concat()" ....) since I have to repeat this technique on multiple fields.

But thanks for great suggestion!

Regards,

Vladimir

[swuehl]

I assume your values contain spaces. If so, you would need to use quotes:

("AA A"|"BB B")

[vlad_komarov]

Yes, using double quotes helped a bit

I am using composite values separator ["|"], so the final variable looks like:

= '("' & getFieldSelections(ACCOUNT_TYPE_ABBREV, '"|"') & '")'

And it seems to work faster than Concat().

Thanks!

VK