Can anybody please help me out with the following issue that I am facing?
I have characteristic called 'Country' which has two Subordinate value nodes Europe, North America. The characteristic 'Country' can have multiple values and is 'Character' format. Under 'Europe' node, I have subordinate values such as 'France', 'England'. Under 'North America' node, I have subordinate values such as 'Canada', 'USA'.
The issue which I am facing is that while creating a procedure, I am unable to use statements such as IF Country IN ('3', '4') *where 3 is for France and 4 is for England.
Is there any way I can use the 'IN' statement for subordinate values or is there an alternative way?
My country list is quite big per continent so I don't want to use a statement like:
IF Country = '3' OR Country = '4' OR...
Please help me out with this.
Thanks in advance,
With best regards,