Sort.nullsLast

Property Description

Whether query results with null values are listed at the end of the query results.

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

The default value of this property is the value of the Sort.ascending property. For example, if the Sort.ascending property is set to true, the Sort.nullsLast property is also set to true.

Type

boolean

Module

N/query Module

Parent Object

query.Sort

Sibling Object Members

Sort Object Members

Since

2018.2

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 theNullsLast = myCustomerQuery.sort[0].nullsLast;
...
// Add additional code

Syntax

Related Topics