how to create a query for opportunity record?

AI generated answer (using internal Slack threads):

To create a query for an opportunity record in NetSuite, you can use SuiteScript or SuiteQL. Here's an example of how you can do it using SuiteScript:

javascript
var search = require('N/search');

var opportunitySearch = search.create({
   type: search.Type.OPPORTUNITY,
   filters: [
      ['status', 'anyof', 'Opportunity:W']
   ],
   columns: [
      'tranid',
      'entity',
      'statusRef'
   ]
});

var searchResult = opportunitySearch.run().getRange({
   start: 0,
   end: 100
});

for (var i = 0; i < searchResult.length; i++) {
   var tranid = searchResult[i].getValue({
      name: 'tranid'
   });
   var entity = searchResult[i].getValue({
      name: 'entity'
   });
   var statusRef = searchResult[i].getValue({
      name: 'statusRef'
   });

   log.debug('Opportunity ID: ' + tranid + ', Entity: ' + entity + ', Status: ' + statusRef);
}

This script creates a search for opportunities with a status of 'Won'. It then retrieves the transaction ID, entity, and status for each opportunity. If you want to get a list of contacts on the opportunity via a saved search, you can use the 'contact' join in your search. Here's an example:

javascript
var search = require('N/search');

var opportunitySearch = search.create({
   type: search.Type.OPPORTUNITY,
   filters: [
      ['status', 'anyof', 'Opportunity:W']
   ],
   columns: [
      'tranid',
      'entity',
      'statusRef',
      search.createColumn({
         name: 'entityid',
         join: 'contact'
      })
   ]
});

var searchResult = opportunitySearch.run().getRange({
   start: 0,
   end: 100
});

for (var i = 0; i < searchResult.length; i++) {
   var tranid = searchResult[i].getValue({
      name: 'tranid'
   });
   var entity = searchResult[i].getValue({
      name: 'entity'
   });
   var statusRef = searchResult[i].getValue({
      name: 'statusRef'
   });
   var contact = searchResult[i].getValue({
      name: 'entityid',
      join: 'contact'
   });

   log.debug('Opportunity ID: ' + tranid + ', Entity: ' + entity + ', Status: ' + statusRef + ', Contact: ' + contact);
}

This script adds a column for the contact entity ID to the search results. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******