N/query Module
Query.runPaged()
Method Description: Executes the query and returns a query.PagedData object that represents the paged query results. You can iterate over this object to obtain each page of query results. For paged queries, the maximum number of result rows per page is 1000. The minimum number of result rows per page is 5, except for the last page in the result set (because the last page may include fewer than 5 results).
Returns: query.PagedData
Supported Script Types: Client and server scripts For more information, see SuiteScript 2.0 Script Types.
Governance: 10 units
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.runPaged()

// Code Example 1

// Add additional code

//...

var myTransactionQuery = query.create({

    type: query.Type.TRANSACTION

});



var myEntityJoin = myTransactionQuery.autoJoin({

    fieldId: 'entity'

});



myTransactionQuery.columns = [

    myEntityJoin.createColumn({

        name: 'subsidiary'

    })

];



myTransactionQuery.sort = [

    myTransactionQuery.createSort({

        column: myTransactionQuery.columns[0],

        ascending: false

    })

];



var results = myTransactionQuery.runPaged({

    pageSize: 10

});



// Use the count property to count the

// search results easily

var resultCount = myTransactionQuery.runPaged({

    pageSize: 10

}).count;

//...

// Add additional code



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