SuiteScript Filter Expressions

I’m writing this for a colleague, but figured it wouldn’t hurt to put it somewhere where I can find it again for myself!

Start here. This is another post that describes how to set up a custom record type called “Consignment Inventory.” Here’s what you get from that.

Consignment Inventory Definition

Now, let’s create some SuiteScipt server-side code to read that custom record type using a filter expression. It should be pretty self-explanatory.

FilterExpression Code Example

Here is a link to a SuiteAnswers article that includes all the SuiteScript 1.0 filter operators.

And here is the code that you can paste into your project.

var my_namespace = {
useFilterExpression: function() {
var filterExpression = [
[‘custrecord_logic_consign_lead_time’, ‘greaterthan’, 0]
, ‘and’,
[‘custrecord_logic_consign_lead_time’, ‘notgreaterthan’, 14]
var columns =new Array();
columns[0] = new nlobjSearchColumn(‘custrecord_logic_consignment_item’);
columns[2] = new nlobjSearchColumn(‘custrecord_logic_consign_lead_time’);
var searchResults = nlapiSearchRecord(‘customrecord_logic_consignment_inventory’, null, filterExpression, columns);
var result =new Array();
if (searchResults) {
for (var i =0; i < searchResults.length; i++) {
‘item’ : searchResults[i].getValue(‘custrecord_logic_consignment_item’)
, ‘leadtime’ : searchResults[i].getValue(‘custrecord_logic_consign_lead_time’)


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s