Issue with in() function in expression

1

Hi guys,

I am trying to organize my workflow based on "options", that are defined in a multiple choice parameter. I then dervie a parameter table and define On condition test to execute, or not, parts of my workflow.

Problem I am facing : if I check only one option, or no option, it is working as expected. If I do check 2 options, instead of getting TRUE for the individual tests, I get FALSE.

Please find basic test project enclosed that does reproduce the issue. I did test in expressions at derive Action level, as well with a Calculate new column action, both on parameter itself and column value. The same problem occurs every time.

Thanks and regards,
IN_OPERATOR_ISSUE_WITH_ONCONDITION_DERIVATION.morph (4.7 KB)

2

Hi @David_Juras,

If you swap the first and second function arguments, it should work. The function In is defined as follows: In(text, look_in, delimiter). The look_in parameter is intended to be the set of options, while text is the option you are checking.
Please let me know if this makes sense. I can see why it might be confusing.

3

Hi @vlad_dzhos

Thanks a lot ! Obviously, yes, it works now...

I am feeling stupid :wink: documentation is clear on this, but many other such text functions in Easymorph are working the other way around (Find, Contains, and so on). And I tricked myself :slight_smile:

1 Like