query.Page

Object Description

One page of the paged query results.

Supported Script Types

Client and server scripts

For more information, see SuiteScript 2.x Script Types.

Module

N/query Module

Methods and Properties

Page 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.createColumn({
            fieldId: 'firstname'
        }),
        myCustomerQuery.createColumn({
            fieldId: 'email'
        })
    ];
    var myPagedResults = myCustomerQuery.runPaged({
        pageSize: 10
    })

    // Fetch results using an iterator
    var iterator = myPagedResults.iterator();
    iterator.each(function(resultPage) {
        var currentPage = resultPage.value;
        log.debug(currentPage.pageRange.size);
        return true;
    });

    // Alternatively, fetch results using a loop
    for (var i = 0; i < myPagedResults.pageRanges.length; i++) {
        var currentPage = myPagedResults.fetch(i); log.debug(currentPage.pageRange.size);
    }
...
// Add additional code

Syntax

Related Topics