「ネットスイート」顧客のユーザノートを検索するサンプル

// 顧客とJOIN、内部ID 53482指定
var filters = new Array();
filters.push(new nlobjSearchFilter( 'internalid', 'customer', 'is', '53482' ));
 
// 閲覧するcolumns を指定
var columns = new Array();
columns.push(new nlobjSearchColumn('author'));
columns.push(new nlobjSearchColumn('direction'));
columns.push(new nlobjSearchColumn('externalid'));
columns.push(new nlobjSearchColumn('formulacurrency'));
columns.push(new nlobjSearchColumn('formuladate'));
columns.push(new nlobjSearchColumn('formuladatetime'));
columns.push(new nlobjSearchColumn('formulanumeric'));
columns.push(new nlobjSearchColumn('formulapercent'));
columns.push(new nlobjSearchColumn('formulatext'));
columns.push(new nlobjSearchColumn('internalid'));
columns.push(new nlobjSearchColumn('note'));
columns.push(new nlobjSearchColumn('notedate'));
columns.push(new nlobjSearchColumn('notetype'));
columns.push(new nlobjSearchColumn('title'));
 
// 検索を実行
var searchresults = nlapiSearchRecord( 'note', null, filters, columns );