We have the following Suitelet we are working on to communicate with a mobile device. Although I was aware of the 1,000 record limit on search results, we would prefer not to do extra programing on the device to manage which results it received and didn't. Is there a way to get around the 1,000 record limit on searches and any example would be greatly appreciated. Thanks for any help.
---------
function get(datain)
{
// define search filters
var filters = new Array();
filters[0] = new nlobjSearchFilter( 'isinactive', null, 'is', 'F' );
//filters[1] = new nlobjSearchFilter( 'custrecord_side_direction', null, 'is', 'N' );
// return lat, long , city, state
var orders = new Array();
var columns = new Array();
columns[0] = new nlobjSearchColumn( 'custrecord_longitude' );
columns[1] = new nlobjSearchColumn( 'custrecord_latitude' );
columns[2] = new nlobjSearchColumn( 'custrecord_city' );
columns[3] = new nlobjSearchColumn( 'custrecord_state' );
// execute the meter search, passing all filters and return columns , filters, columns
var searchResults = nlapiSearchRecord( 'customrecord_onstreet_parking_regulation', null, filters, columns );
if(searchResults == null)
{
nlapiLogExecution('DEBUG', 'searchResults', 'no records found');
}
nlapiLogExecution('DEBUG', 'searchresults', searchResults);
// loop through the results
for ( var i = 0; searchResults != null && i < searchResults.length; i++ )
{
// get result values
var searchresult = searchResults[ i ];
var record = searchresult.getId( );
var rectype = searchresult.getRecordType( );
var custrecord_longitude = searchresult.getValue( 'custrecord_longitude' );
var custrecord_latitude = searchresult.getValue( 'custrecord_latitude' );
var custrecord_city = searchresult.getValue( 'custrecord_city' );
var custrecord_state = searchresult.getValue( 'custrecord_state' );
orders[orders.length++] =
new order (custrecord_longitude,custrecord_latitude,custrecord_city,custrecord_state);
}
var results = new Object();
results['searchResults'] = orders;
return results;
}
//function to create a new object called order
function order (custrecord_longitude,custrecord_latitude,custrecord_city,custrecord_state)
{
this.custrecord_longitude = custrecord_longitude;
this.custrecord_latitude = custrecord_latitude;
this.custrecord_city = custrecord_city;
this.custrecord_state = custrecord_state;
}