Convert a Query to a SuiteQL and Run It
The following sample creates a query for customer records, converts it to its SuiteQL representation, and runs it.
Note:
This sample script uses the require
function so that you can copy it into the SuiteScript Debugger and test it. You must use the define
function in an entry point script (the script you attach to a script record and deploy). For more information, see SuiteScript 2.x Script Basics and SuiteScript 2.x Script Types.
/**
* @NApiVersion 2.x
*/
require(['N/query'], function(query) {
var myCustomerQuery = query.create({
type: query.Type.CUSTOMER
});
myCustomerQuery.columns = [
myCustomerQuery.createColumn({
fieldId: 'entityid'
}),
myCustomerQuery.createColumn({
fieldId: 'email'
})
];
myCustomerQuery.condition = myCustomerQuery.createCondition({
fieldId: 'isperson',
operator: query.Operator.IS,
values: [true]
});
var mySQLCustomerQuery = myCustomerQuery.toSuiteQL();
var results = mySQLCustomerQuery.run();
});