I'm writing a SuiteQL, so far, so good but now I h...
# general
s
I'm writing a SuiteQL, so far, so good but now I have a problem. I have to access a "List" (Customizations->List, Records & Fields -> List). What is the database file name ?
t
@Simon When you create a custom list, NetSuite creates a table to store its values, and it uses the list's ID as the name of the table. For example, if the list's ID is "customlist1," then you could query it like this:
SELECT * FROM CUSTOMLIST1
Also, if you'd like to get all of an instance's custom lists, you can query the CustomList table:
SELECT * FROM CustomList
I hope that helps.
s
Strange I don't have a CustomList but I'm using RazorSQL. Let me try with your SuiteQL suitelet