join is also the second parameter of the `nlobjSea...
# suitescripte
erictgrubaugh
02/09/2017, 1:58 PMjoin is also the second parameter of the
nlobjSearchColumnnew nlobjSearchColumn('quantitypicked', 'transaction')j
jake
02/10/2017, 2:50 AMerictgrubaugh: do I still need to include the transaction in the searchFilter?
jake
02/10/2017, 2:51 AMmy search filter looks like this
jake
02/10/2017, 2:51 AMfilters[0] = new nlobjSearchFilter( 'inventorylocation', null, 'anyof', location );
filters[1] = new nlobjSearchFilter('internalid', null, 'anyof', item);
//filters[2] = new nlobjSearchFilter('item', 'inventorycount', 'anyof', item);
jake
02/10/2017, 3:45 AMI'm confused. How come I can use 'transaction' with join but not ' inventorycount'?
e
erictgrubaugh
02/10/2017, 5:16 AMSee the Records Browser for Transactions for your available joins: https://system.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_2/script/record/transaction.html
erictgrubaugh
02/10/2017, 5:16 AMinventorycountj
jake
02/10/2017, 6:15 AMhow to know if it is a valid join?
e
erictgrubaugh
02/10/2017, 6:15 AMThe Records Browser lists all valid search joins, filters, and columns for nearly every record type
jake
02/10/2017, 6:16 AMthere is an inventorycount though
jake
02/10/2017, 6:16 AMI dont get it.
e
erictgrubaugh
02/10/2017, 6:16 AMBut you are not searching on the Inventory Count record
erictgrubaugh
02/10/2017, 6:17 AMYou have to look at the page for record type you are searching
j
jake
02/10/2017, 6:20 AMI see. I think I was reading an old version of the records browser. Thanks for sharing!