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

how can i get matrixoptionlist using suiteql

&gt;*AI generated answer (using internal Slack threads):*
To get the matrixoptionlist using SuiteQL, you would need to query the CustomField table. However, please note that SuiteQL does not directly support querying matrixoptionlist. 

Here is a sample query to get custom column fields:

```sql
SELECT scriptid FROM CustomField WHERE fieldtype = 'COLUMN'
```

This query will return all the custom column fields in your account. You can modify the WHERE clause to filter the results based on your needs.

******
Disclaimer:

This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes.
******

&gt;*Slack thread 1:* <https://netsuiteprofessionals.slack.com/archives/C2K2RJNAC/p1639521117078100|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.788280427

&gt;*Slack thread 2:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1612482805113900|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.761894822

&gt;*Slack thread 3:* <https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1602783638336600|here> (available only if the original thread was posted in the last 90 days)
&gt;*Similarity score:* 0.760779321



Please provide your feedback on this answer.

it returns all the customfield
i only wants to get the list of matrix option that i have created like size color and parts
all of these have enabled matrix option
how can i get only these custom fields

The agent isn’t yet programmed to answer follow-up questions in thread. But you can ask again in the main channel.