Using a Saved Search in SS2.0, what would be the b...
# suitescript
t
Using a Saved Search in SS2.0, what would be the best way create a filter that checks if a Multi-Select field contains a string value?
After struggling with finding the right operator, I had success using 'is' as such:
Copy code
search.create({
            type: 'customrecord_ia_approvals',
            filters: [
                ['custrecord_item_categories', 'is', itemCategory]
            ],
e
Does that work if multiple categories are selected?
t
@erictgrubaugh The multiple select field I tested with had 5 options selected, and I was able to query it using a unique value for itemCategory, so it seems it does work. I'm hoping I don't run into some weird issue with it in the future, but for now it seems stable
e
Interesting
Unexpected, but glad it works. Good find