Hello all!
I have a single line text field on my ticket. Sometimes it will contain one "item", other times it might contain multiple separated by a comma (I can change how the data is separated if needed). Using a Insight post-function I am attempting to have the item(s) in the single line text field populate a custom insight field. The post-function I am using is Assign Objects from an IQL query based on data from an issue. The IQL I have entered is as follows: objectType = MYINSIGHTOBJECT AND Name = {MYTEXTFIELD}
This works fine if there is just one item listed in my text field. If there are multiple items listed in the text field, then it doesn't work. I have tried changing my IQL to something like this: objectType = MYINSIGHTOBJECT AND Name IN (${MYTEXTFIELD${0}}), but I think that might be more for insight imports rather than IQL, but I could be wrong.
I am open to any ideas on how to either adjust my IQL in the post-function or how I need to have the data populate in the text field to make it select items. My custom insight field I am trying to populated with the post function is set to allow multiple selections.
Thanks!