Maybe I am just blanking, but if there an easy way...
# suiteanalyticss
Sandii
03/29/2021, 8:10 PMMaybe I am just blanking, but if there an easy way to make search criteria on a multi-select field that is equivalent to
is not emptynoneof - None -LENGTH()k
KevinJ of Kansas
03/29/2021, 11:39 PMMaybe concatenate your field with a comma
KevinJ of Kansas
03/29/2021, 11:40 PMCase when {field}||','= ',' then 1 else 0 end and look for a 1
s
Sandii
03/30/2021, 2:15 PMCONCAT and the pipe notation both yield unexpected error when the field is multiselect
k
KevinJ of Kansas
03/30/2021, 3:22 PMoh wait - you're looking for ones that have a value
KevinJ of Kansas
03/30/2021, 3:22 PMand aren't empty.
KevinJ of Kansas
03/30/2021, 3:24 PMI think you've got a different issue with your search:
this works
s
Sandii
03/30/2021, 3:51 PMits this stupid field specifically I believe
Sandii
03/30/2021, 3:51 PMsame thing gives me unexpected error
Sandii
03/30/2021, 3:52 PMit's not exposed to N/query at all which would be my preferred way to get the information, it's the advanced bom default for location column on assembly item records
k
KevinJ of Kansas
03/30/2021, 4:02 PMif you remove that from your criteria and pull it into your results does it still bomb?
KevinJ of Kansas
03/30/2021, 4:04 PMalso - the fact that it's a location join related to an item makes me believe you'll likely never get it to work.
KevinJ of Kansas
03/30/2021, 4:04 PMalso - is that even really a multiselect field?
s
Sandii
03/30/2021, 4:18 PMyes it is a multiselect, a revision can be either the master default, or the default for one or many locations
Sandii
03/30/2021, 4:20 PMAnd yes it still bombs just as a formulatext like
{assemblyitem.locations} || ','Sandii
03/31/2021, 3:10 PMI'm just running an initial search to get the list of location ids and using a
location anyof [allTheLocations]11 Views