https://netsuiteprofessionals.com logo
d

depthless

05/06/2022, 5:08 PM
anyone know how to find the table for a custom segment in NetSuite2.com via ODBC?
tried searching for its name
and it's id, nothing
pretty strange that i can find it using suite analytics
t

tdietrich

05/06/2022, 10:55 PM
@depthless I think this is how you'd do it with SuiteQL: -- Use this to get the "RecordType." -- In my case, 275 is the RecordType.
SELECT TOP 10 * FROM CustomSegment
-- Use this to get the ScriptID. -- In my case, CUSTOMRECORD_CSEG_REGION is the ScriptID.
SELECT TOP 10 * FROM CustomRecordType WHERE InternalID = 275
-- The ScriptID is the name of the custom table with the segment's values.
SELECT TOP 10 * FROM CUSTOMRECORD_CSEG_REGION
Hope that helps. Have a great weekend!
❤️ 1
d

depthless

05/09/2022, 1:43 PM
hmmm
@tdietrich, same problem
Description Resource Path Location Type SQL Error [10129] [42S02]: [NetSuite][SuiteAnalytics Connect JDBC Driver][OpenAccess SDK SQL Engine]Base table:CUSTOMRECORD_CSEG_PRODUCT not found.
I see the script_id, in the 2nd query
oh, probably my role
yeah.. sorry
2 Views