write a suiteql query that will find the id of a custom segment value by its fullname (not just name)

AI generated answer (using internal Slack threads):

To find the ID of a custom segment value by its fullname using SuiteQL, you can use a query similar to the one below:

sql
SELECT id 
FROM customrecord_cseg_mysegment 
WHERE name = 'Your Full Name'

In this query, replace 'customrecord_cseg_mysegment' with the name of your custom segment and 'Your Full Name' with the fullname of the custom segment value you are looking for. Please note that the name of the custom segment table in SuiteQL corresponds to the name of the custom segment in NetSuite. Also, the 'name' field in the WHERE clause corresponds to the fullname of the custom segment value. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******