I am hoping someone can tell me if they have had any luck writing queries that return values entered in a multi-select. For example for Change Management, we are currently using a multi-Select for impacted or effected CIs in a Multi-Select field. The problem here is that when trying to modify the Change search query, we cannot create a filter that lets you accurately query a value contained within that CI multi-Select.
It is not just in this module either, I have noticed globally that I cannot search for values in a multi-Select field with any reliability. Has anybody figured out a reliable way to make this work? If so, I would love to know. Thank you.