Convert a Query to SuiteQL and Run It

The following sample creates a query for customer records, converts it to its SuiteQL representation, and runs it.

/**
 * @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();
});