Modules

filter

 

Objects/Functions

module (N/query)

SuiteScript 2.0

Sort.nullsLast

// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=Sort.nullsLast for more information.

N/query Module
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
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=Sort.nullsLast

Example:

// Code Example 1
// 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

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