Search code examples
projectnetsuitejobs

How to access Netsuite Project (recordtype=job) using SuiteAnalytics Connect?

How can I access Netsuite projects (recordtype=job) using Suiteanalytics Connect to create queries? I'm not able to find the records into these tables:

enter image description here

enter image description here

Solution

  • To access the projects you need to do as follows:

    select * from customers where customer_id='xxx';

    Note: customer_id is the internal id of the Project record.