Modules

filter

 

Objects/Functions

module (N/dataset)

SuiteScript 2.0

Main Examples

N/dataset Module
Member Type: Name
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=N/dataset Module

// Code Example 1
/**
* @NApiVersion 2.x
*/

// The following script creates a dataset with three columns, one of which is based on a join, and a condition. Then, all datasets are listed and the newly created dataset is loaded and reviewed.

require(['N/dataset', 'N/query'], function(dataset, query){
var myTransactionDateColumn = dataset.createColumn({
fieldId: 'trandate',
alias: 'date'
});
var myJoin = dataset.createJoin({
fieldId: 'createdby',
target: 'entity'
});
var myNameColumn = dataset.createColumn({
fieldId: 'lastname',
alias: 'name',
join: myJoin
});
var myTransactionIdColumn = dataset.createColumn({
fieldId: 'tranid',
alias: 'id'
});
var myTotalColumn = dataset.createColumn({
fieldId: 'foreigntotal',
alias: 'total'
});
var myColumns = [myTransactionIdColumn, myNameColumn, myTransactionDateColumn, myTotalColumn];
var myCondition = dataset.createCondition({
column: myNameColumn,
operator: query.Operator.EMPTY
});
var myDataset = dataset.create({
type: 'transaction',
columns: myColumns,
condition: myCondition,
name: 'My Transaction Dataset',
description: 'This is my transaction dataset.'
});

// List all created datasets
var allDatasets = dataset.list();
log.debug({
title: 'All datasets:',
details: allDatasets
});

// Review the newly created dataset components (in the log)
log.debug({
title: 'My Dataset = ',
details: myDataset
});

// Now run the dataset
var runResult = myDataset.run();
var runPagedResult = myDataset.runPaged({
pageSize: 2
});
log.debug({
title: 'runResult: ',
details: runResult
});
log.debug({
title: 'runPagedResult: ',
details: runPagedResult
});
});

// Code Example 2
/**
* @NApiVersion 2.x
*/

// The following script lists all existing datasets and then loads the first dataset.

require(['N/dataset'], function(dataset){
// List all created datasets
var allDatasets = dataset.list();
log.debug({
title: 'All datasets:',
details: allDatasets
});

// Load the first dataset
var myFirstDataset = dataset.load({
id: allDatasets[0].id
});
log.debug("myFirstDataset:", myFirstDataset);
});

//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=article_158946741680.html