what is the easiest way to get all the values/IDs ...
# suitescripta
Akbeard
09/14/2020, 8:07 PMwhat is the easiest way to get all the values/IDs in a customlist, given the internalid or customlist_ id of the list ?
s
Sandii
09/14/2020, 8:16 PMThe same way its doing it right? Just create a saved search on the list/record type and get the id's off the results.
Sandii
09/14/2020, 8:19 PMThis is working in the chrome console
Copy code
let res = search.create({type: 'customlist_idhere', filters: [], columns: ['internalid', 'name']}).run().getRange(0,100).map(res => res.toJSON().values)e
erictgrubaugh
09/14/2020, 9:28 PMYou may want a filter on
isinactive