Comparing against an Active List
I've been searching the forum before posting the question. I´ve got a field (string) which contains two or more words and I´ve got a list with about 1400 entries (one string for entry). I need to know if there is any list entry is contained in the field.
The "inActiveList" condition is not valid because a match is required. The GetActiveListValue variable is not valid for the same reason.
I know that I can´t make a condition like: field CONTAINS (activeList_entry). //Scroll through the list to see if any entry is valid
I´ve seen a possible solution, but it needs the use of variables and regex to create a Velocity, but with 1400 posibilities I think that it is not workable.