permissions required, and suiteql syntax to access a custom record of a specific record type that is linked to customers?

AI generated answer (using internal Slack threads):

To access a custom record of a specific record type that is linked to customers, you need to have the necessary permissions and use the correct SuiteQL syntax. Permissions: 1. You need to have the 'Custom Record Entries' permission set to 'Full' in your role. This allows you to access custom records. 2. If the custom record is linked to customers, you also need to have the 'Customers' permission set to 'Full'. 3. If you are using SuiteQL to query the custom records, you need to have the 'SuiteQL' permission set to 'Full'. 4. If the custom record is a custom list, you need to have the 'Lists' permission set to 'Full'. SuiteQL Syntax: To query a custom record using SuiteQL, you can use the following syntax:

code
var suiteQL = `SELECT * FROM customrecord_your_custom_record WHERE custrecord_linked_customer = ${customerID}`;
var suiteQLResult = query.runSuiteQL(suiteQL);

In the above code, replace 'customrecord_your_custom_record' with the script ID of your custom record and replace 'custrecord_linked_customer' with the script ID of the field in your custom record that links to the customer. Replace

${customerID}

with the internal ID of the customer you want to query. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******