are custom segments supported in suiteql? if yes, how do I reference it in the query?

@tech_ph2019 You can get the IDs of the custom segments using this:

SELECT * FROM CustomSegment

Then use the "scriptid" as the table name to get values for a specific segment. For example:

SELECT
	CUSTOMRECORD_CSEG1.ID,
	CUSTOMRECORD_CSEG1.Name,
	*
FROM 
	CUSTOMRECORD_CSEG1

thanks @tdietrich! I will try that out

@tech_ph2019 There should be a mapping table between that maps the Budgets table to the custom segment. For example: SELECT mapone FROM MAP_customrecord_cseg1_cseg1_filterby_location To find the table name, you could use the SuiteQL Query Tool's Tables Reference.

thanks!

I have filed a defect for SuiteQL with Budget records. It was returning duplicate lines when every other field was same except the custom segment. It was a show stopper for the client but NetSuite has provided a date of 2023.2 release.

@NickSuite May I know how you got to show the custom segment values from your budget query?

If I remember correctly, I got the ideas from SuiteQL of the budget record and then used saved search.