Modules
Objects/Functions
SuiteScript 2.0
// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=dataset.Dataset for more information.
N/dataset Module
dataset.Dataset
Object Description:
Encapsulates the entire dataset, including columns, conditions, and joins.
This object is created using the dataset.create(options) method.
For a complete list of this object’s properties, see Dataset Object Members.
Supported Script Types:
Server scripts
For more information, see SuiteScript 2.0 Script Types.
Module:
N/dataset Module
Methods and Properties:
Dataset Object Members
Since:
2020.2
Search NetSuite -
https://system.netsuite.com/app/help/helpcenter.nl?search=dataset.Dataset
Example:
// Code Example 1
// Add additional code
//...
// Create a basic Dataset
var myDataset = dataset.create({
type: 'transaction'
});
// Create a comprehensive (full) Dataset
var myDataset = dataset.create({
type: 'transaction',
name: 'My Transaction Dataset',
id: 'custdataset_dataset',
description: 'My comprehensive transaction dataset that includes columns and a condition',
condition: myCondition, // Create this using dataset.createCondition
columns: [myColumns] // Create this using dataset.createColumn
});
// Load a dataset and view its Dataset (in the log)
var myDataset = dataset.load({
id: '1' // Replace with a valid ID value for your account
});
var myDatasetDataset = myDataset.Dataset;
// Note that some Dataset properties may be empty/null based on the loaded dataset
log.audit({
title: 'Dataset columns = ',
details: myDatasetDataset.columns
});
log.audit({
title: 'Dataset condition = ',
details: myDatasetDataset.condition
});
log.audit({
title: 'Dataset description = ',
details: myDatasetDataset.description
});
log.audit({
title: 'Dataset id = ',
details: myDatasetDataset.id
});
log.audit({
title: 'Dataset name = ',
details: myDatasetDataset.name
});
log.audit({
title: 'Dataset type = ',
details: myDatasetDataset.type
});
//...
// Add additional code
//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_158948063457.html