This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

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

<@UK2H57CNR> 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```


Hi <@U856E2SEA> your suggestion worked. Now I want to get the custom segment value from a record. I applied the custom segment to Budgets. I am doing select * from budgets and the custom segment column is not returning

<@UK2H57CNR> 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.

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.

<@UD5AG5SGM> 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.

FYI, I have 2 defects on Budget record with SuiteQL. Defect 653735 and 659820