Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.createTableColumn(options)

{workbook}.createTableColumn({alias: {string},datasetColumnAlias: {string},datasetColumnId: {number},fieldContext: {workbook.FieldContext},filters: {workbook.TableFilter[]},label: ${7:string},sort: ${8:workbook.Sort*},width: ${9:number}})

N/workbook Module
workbook.createTableColumn()
Method Description: Creates a table column. Table columns are used in table definitions, and include an alias, dataset column alias/ID, filters, a label, sorts, and a column width.
Returns: workbook.TableColumn
Supported Script Types: Server scripts For more information, see SuiteScript 2.0 Script Types.
Governance: None
Module: N/workbook Module
Sibling Module Members: N/workbook Module Members
Since: 2020.2
Search NetSuite - https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.createTableColumn(options)

Example:

// Code Example 1
// Add additional code
//...
// Create a basic TableColumn
var myTableColumn = workbook.createTableColumn({
datasetColumId: 1,
sort: mySort
});

// Create a TableColumn with filters
var myTableColumn = workbook.createTableColumn({
datasetColumId: 1,
filters: [myTableFilter],
sort: mySort
});

// Create a complex TableColumn
var myTableColumn = workbook.createTableColumn({
filters: [myTableFilter],
width: 50,
datasetColumnId: 7,
fieldContext: myFieldContext,
label: 'My Complex Table Column',
alias: 'myComplexTableColumn',
sort: mySort
});
//...
// Add additional code

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