N/query Module
Query.sort
Property Description: An array of query.Sort objects used for sorting. This object encapsulates a sort based on the query.Query or query.Component object. The query.Sort object describes a sort that is placed on a particular query result column. To create a sort: Use Query.createSort(options) to create a sort based on the initial query definition created with query.create(options). Use Component.createSort(options) to create a sort based on a join relationship created with Query.autoJoin(options) or Component.autoJoin(options). Assign all created sorts as array values to Query.sort. For an example, see Syntax.
Type: query.Sort[]
Module: N/query Module
Parent Object: query.Query
Sibling Object Members: Query Object Members
Since: 2018.1
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Query.sort

// Code Example 1

// Add additional code

//...

var myCustomerQuery = query.create({

    type: query.Type.CUSTOMER

});



var mySalesRepJoin = myCustomerQuery.autoJoin({

    fieldId: 'salesrep'

});



myCustomerQuery.columns = [

    myCustomerQuery.createColumn({

        fieldId: 'entityid'

    }),

    mySalesRepJoin.createColumn({

        fieldId: 'firstname'

    }),

    mySalesRepJoin.createColumn({

        fieldId: 'email'

    })

];



myCustomerQuery.sort = [

    myCustomerQuery.createSort({

        column: myCustomerQuery.columns[1]

    }),

    mySalesRepJoin.createSort({

        column: myCustomerQuery.columns[0],

        ascending: false

    })

];

//...

// Add additional code



//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_1510781853.html