Skip to content

Instantly share code, notes, and snippets.

@netsuite
Created January 8, 2014 20:03
Show Gist options
  • Save netsuite/8323585 to your computer and use it in GitHub Desktop.
Save netsuite/8323585 to your computer and use it in GitHub Desktop.
Suitelet: Creates a standard Saved Search on the fly using suitelets
function createSavedSearch()
{
var item = request.getParameter('itemid'); // Get parameter
// Required paremeter for jsonp requests
// var callback = request.getParameter('callback');
// Define search filters
var filters = [];
filters[0] = new nlobjSearchFilter( 'enter search filter id', null, 'anyOf', item );
//filters[1] = new nlobjSearchFilter( 'projectedamount', null, 'between', 1000, 100000 );
//filters[2] = new nlobjSearchFilter( 'salesrep', 'customer', 'anyOf', -5, null );
// Define search columns
var columns = [];
//columns[0] = new nlobjSearchColumn( 'custrecord_rb_sp_lead_item' );
columns[0] = new nlobjSearchColumn( 'enter search column id' );
columns[1] = new nlobjSearchColumn( 'enter search column id' );
// Run the saved search
var searchresults = nlapiSearchRecord('enter saved search internalid', null, filters, columns );
// Write Response for jsonp requests
//response.write(callback + "(" +JSON.stringify(searchresults) +")");
// Write Response for netsuite hosted requests
response.write(callback + "(" +JSON.stringify(searchresults) +")");
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment