Was it here that I had someone show me how to comp...
# suiteanalyticsk
KevinJ of Kansas
01/29/2021, 8:18 PMWas it here that I had someone show me how to compare a multiselect field to a standard list field in a saved search?
n
Netsuite Tragic
01/30/2021, 5:48 AMI dont know if it was here. If I was checking to see if standard field is in the selections I would be thinking something like CASE WHEN {standard list value} IN {multiselect field} THEN...
k
KevinJ of Kansas
01/31/2021, 5:03 PMThis was suggestion from a colleague of mine.
TO_CHAR(INSTR({multiselect field},{single compare field})) != '0'n
Netsuite Tragic
01/31/2021, 11:36 PMDid either of them work for you?
k
KevinJ of Kansas
02/01/2021, 3:29 PMTrying it out today. The case when in doesn't work
KevinJ of Kansas
02/01/2021, 11:23 PMHaven't had a chance to try it yet :/
KevinJ of Kansas
02/02/2021, 3:05 PMGoing to try this at some point today...
KevinJ of Kansas
02/02/2021, 5:51 PMThis isn't quite working the way I'd hoped - mainly because of false positives.
KevinJ of Kansas
02/02/2021, 5:51 PMStill trying out some other ideas.
KevinJ of Kansas
02/02/2021, 5:57 PMRan out of ideas. Can't source the field from the customer to the transaction in order to join to internal IDs of the ship methods, which would at least reduce the odds of a false positive.
KevinJ of Kansas
02/02/2021, 6:17 PMI solved this - in about the dumbest way possible.
KevinJ of Kansas
02/02/2021, 6:19 PMDumb Solution:
TO_CHAR(INSTR({customer.custentity_po_free_ship_methods}||',',{shipmethod}||','))✅ 1