Sorry for the confusion, let me ask the question a...
# suiteqls
Simon
09/01/2023, 1:00 PMSorry for the confusion, let me ask the question a different way.
The field custrecord_kk_pw_ship_method is a multi-select
Using SuiteQL I want to read all records where custrecord_kk_pw_ship_method contains 61129
Any idea how to do it
c
Clay Roper
09/01/2023, 1:37 PMStart here
s
Simon
09/01/2023, 5:34 PMFound it
Simon
09/01/2023, 5:34 PMselect customrecord_pick_wave.id,BUILTIN.DF(customrecord_pick_wave.custrecord_kk_pw_ship_method) as shipmethods_name from customrecord_pick_wave JOIN map_customrecord_pick_wave_custrecord_kk_pw_ship_method MAP ON MAP.mapone = customrecord_pick_wave.id JOIN shipitem ON MAP.maptwo = shipitem.id and shipitem.id =61129
4 Views