Dataset.getExpressionFromColumn(options)
Method Description |
Returns an expression which can be used in workbook. |
Returns |
|
Supported Script Types |
Server scripts For more information, see SuiteScript 2.x Script Types. |
Governance |
None |
Module |
|
Parent Object |
|
Sibling Object Members |
|
Since |
2020.2 |
Parameters
The options
parameter is a JavaScript object.
Parameter |
Type |
Required / Optional |
Description |
---|---|---|---|
|
number |
required if |
The ID of the column. |
|
string |
required if |
The alias of the column. |
Errors
Error Code |
Thrown If |
---|---|
|
Both the |
|
Neither the |
Syntax
The following code sample shows the syntax for this member. It is not a functional example. For a complete script example, see N/dataset Module Script Samples. Also see the Tutorial: Creating a Dataset Using the Workbook API topic.
// Add additional code
...
// Load a dataset that includes a column that has an expression
var myDataset = dataset.load({
id: 'stddataset_mydataset' // Replace with a valid ID value for your account
});
var myWorkbookExpressionId = myDataset.getExpressionFromColumn({
columnId: 15
});
var myWorkbookExpressionAlias = myDataset.getExpressionFromColumn({
columnId: 16
alias: 'myExpression'
});
log.debug({
title: "myWorkbookExpression: ",
details: myWorkbookExpression
});
...
// Add additional code