There is any way to use the N/query to get values ...
# suitescript
a
There is any way to use the N/query to get values from custom lists?
s
SELECT * FROM customlist_my_cool_list
?
t
There's also the "CustomList" table that you can query to get the custom lists in the account, including script IDs, names, etc.
a
I need to query multiple custom list... basically I have 20 fields using 20 different custom lists and I need to query that without doing 20 different queries or searches.
t
I suppose you could query the CustomList table to get the list names, and then use those to dynamically build a query like this:
Copy code
SELECT 'CUSTOMLIST_VB_MEMO_LIST' AS List, * FROM CUSTOMLIST_VB_MEMO_LIST
UNION
SELECT 'CUSTOMLIST_IL_ARTWORK_APPROVAL' AS List, * FROM CUSTOMLIST_IL_ARTWORK_APPROVAL