Beau
09/17/2021, 7:00 PMinternalid
(eg: 413)?
I've learned (thanks to @battk!!) how to load a customlist as a search (via search.create({ type:'customlist_sizes'})
, but this only gives me the sublist of values and not anything related to the customlist's main line fields. Thanks1tdietrich
09/17/2021, 8:13 PMSELECT
ID,
Name,
ExternalID
FROM
CUSTOMLIST404
WHERE
IsInactive = 'F'
ORDER BY
Name
Does that help?battk
09/17/2021, 8:23 PMcustomlist
searchbattk
09/17/2021, 8:26 PMcustomlist
tableBeau
09/17/2021, 8:30 PMbattk
09/17/2021, 8:34 PMbattk
09/17/2021, 8:35 PMMark Robinson
09/17/2021, 8:36 PMvar list_search = nlapiSearchRecord('customlist', null, [new nlobjSearchFilter('scriptid',null,'is','my_cust_search')],null);
The id should come up on the result setBeau
09/17/2021, 8:46 PMscriptid
and saved search was the secret to getting thereMark Robinson
09/17/2021, 8:47 PMBeau
09/17/2021, 8:47 PMcustomlist
table where i can see all custom lists? thank you thoughBeau
09/17/2021, 8:50 PMSELECT * FROM customlist
in SuiteQL and that gives me the list of ids and "scriptids" too...I learned a lot from this thanks for everyone's feedback!!