i'm trying to find records where a multi-select fi...
# suitescript
b
i'm trying to find records where a multi-select field doesn't have any items selected in it ... and none of the options I've tried are working (noneof "none" for example). what is the trick to this?
b
anyof none
b
i'm sorry. I mis-wrote my question. I'm trying to find records where the multi-select field is NOT empty. In other words, at least one option is selected.
k
I tried that today and it wasn’t working in a script search. Had to revert to anyof and select all values lol
b
yes ... it just seems hard to believe that there is no way to do t his correctly
k
Well I tried and really Cba to raise a support ticket due to it not working properly
b
["NOT",["custrecord_my_multiselect","anyof","@NONE@"]]
thinking 1
m
In the UI, I've used a text formula, e.g.
{multi_select_field_id}
with the 'is not empty' filter. For a scripted search I like @battk’s solution, especially if you're already using filter expressions instead of Search.Filter objects.