Sort.column

Property Description

The query result column that the query results are sorted by.

This property is set during the execution of Query.createSort(options) and Component.createSort(options).

Type

query.Column (read-only)

Module

N/query Module

Parent Object

query.Sort

Sibling Object Members

Sort Object Members

Since

2018.1

Syntax

Important:

The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/query Module Script Samples.

            // Add additional code
...
    var myCustomerQuery = query.create({
        type: query.Type.CUSTOMER
    });
    myCustomerQuery.columns = [
        myCustomerQuery.createColumn({
            fieldId: 'entityid'
        })
    ];
    myCustomerQuery.sort = [
        myCustomerQuery.createSort({
            column: myCustomerQuery.columns[0],
            ascending: false,
            caseSensitive: true,
            locale: query.SortLocale.EN_CA,
            nullsLast: false
        })
    ];
    var theColumn = myCustomerQuery.sort[0].column;
...
// Add additional code

Syntax

Related Topics