Hi, using local variable, i am calling expression rule, which gives category codes as output, now i neeed to convert this local!updatecategorycodes into array form to use contains() function.
can anyone please help me
local!updateCategoryCodes:index( rule!CNAM_qeGetUpdateCategoryCodes(), "CATEGORY_CODE", "" ),
Discussion posts and replies are publicly visible
I'm not sure I understand the problem. Assuming the result of rule!CNAM_qeGetUpdateCategoryCodes() is a list of items, then index() WILL return an array to local!updateCategoryCodes, even if the list only has one item in it,.
Just realized that you may be facing the issue that the index() is returning a List of Variant, and that you may be attempting to reference an item as a string in your contains() function. If so, you need to make sure that both data types are equivalent i.e. turn you List of Variant into a List of Text String by using fn!touniformstring()