I’ve created a customlist (customlist_item_subclassification) which is used in a custom Item Field of type MultipleSelect (custitem_subclassification)
Does anyone know how I join this in N/query? For example, if I want to retrieve all items where they are subclassified with id 3? Note that the item could be in multiple subclasses.
I’m not sure how to join to a MultipleSelect list. I can see that the IDs are coming out in one column, comma separated...