Hi Experts!
While programing a logic script, i need to do a selection in %category_set% variable. But when the variable is populated with more than 1 result, it doesn't bring any result.
this is the sentence: *SELECT(%N1_CATEGORY%,"N1_CATEGORY","CATEGORY","ID IN ('%CATEGORY_SET%')")
I think it could be because %CATEGORY_SET% variable is a comma delimited list and the in sentence doesn´t work against this type of lists.
How do you solve this problem?
Any advice on this?
Thanks in advance