1. SuiteCloud Platform
  2. SuiteScript
  3. SuiteScript 2.x
  4. Transitioning from SuiteScript 1.0 to SuiteScript 2.x
  5. Sample SuiteScript 1.0 to SuiteScript 2.0 and SuiteScript 2.1 Conversions
  6. Create and run a joined search

Create and run a joined search

This sample is a custom module script that creates and runs a joined search. This sample can be used as a custom module or as an individual function within a user event or other server script, so no JSDoc or define statement or return statement or entry point function is needed. But you will need to load the N/search module for the function to work.

The conversion of this script from SuiteScript 1.0 to SuiteScript 2.x includes the following:

SuiteScript 1.0 Script

SuiteScript 2.x Script

 
                    function myJoinedSearch() {
    // Create a filters array and define search filters for an Item search
    var filters = new Array();

    // filter by a specific customer (121) on the Pricing record
    filters[0] = new nlobjSearchFilter('customer', 'pricing', 'is', '121');

    // filter by a currency type (USA) on the Pricing record 
    filters[1] = new nlobjSearchFilter('currency', 'pricing', 'is', '1');

    // set search return columns for Pricing search
    var columns = new Array();

    // return data from pricelevel and unitprice fields on the Pricing record
    columns[0] = new nlobjSearchColumn('pricelevel', 'pricing');
    columns[1] = new nlobjSearchColumn('unitprice', 'pricing');

    // specify name as a search return column. There is no join set in this field.
    // This is the Name field as it appears on Item records.
    columns[2] = new nlobjSearchColumn('name');

    // execute the Item search, which uses data on the Pricing record as search filters
    var searchresults = nlapiSearchRecord('item', null, filters, columns);
} 

                  
                    function myJoinedSearch () {
    var filters = new Array();
 
    filters[0] = search.createFilter({
        name: 'customer',
        join: 'pricing',
        operator: 'is' ,
        values: '121'

    });
    filters[1] = search.createFilter({
        name: 'currency',
        join: 'pricing',
        operator: 'is' ,
        values: '1'
    });

    var columns = new Array();

    columns[0] = search.createColumn({
        name: 'pricelevel',
        join: 'pricing'
    });
    columns[1] = search.createColumn({
        name: 'unitprice',
        join: 'pricing'
    });
    columns[2] = search.createColumn({
        name: 'name'
    });

    var searchresults = search.run();
}

General Notices