Modules
Objects/Functions
SuiteScript 2.0
// Please search https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.TableFilter for more information.
N/workbook Module
workbook.TableFilter
Object Description:
A table filter. A table filter can be used when you create a table column.
You can create a table filter using workbook.createTableFilter(options).
Supported Script Types:
Server scripts
For more information, see SuiteScript 2.0 Script Types.
Module:
N/workbook Module
Methods and Properties:
TableFilter Object Members
Since:
2020.2
Search NetSuite -
https://system.netsuite.com/app/help/helpcenter.nl?search=workbook.TableFilter
Example:
// Code Example 1
// Add additional code
//...
// Create a TableFilter without values
var myTableFilter = workbook.createTableFilter({
operator: query.Operator.EMPTY
});
// Create a TableFilter with values
var myTableFilter = workbook.createTableFilter({
operator: query.Operator.ANY_OF,
values: {
value1: 'value1',
value2: 'value2',
value3: 'value3'
}
});
// View a workbook.TableFilter in a TableDefinition
var myWorkbook = workbook.load ({
id: myWorkbookId
});
// Note that some TableFilter properties may be empty/null based on the loaded workbook
var myTableFilter = myWorkbook.tableDefinitions[0].columns[0].filters[0]
log.audit({
title: 'TableFilter.operator = ',
details: myTableFilter.operator
});
log.audit({
title: 'TableFilter.values = ',
details: myTableFilter.values
});
//...
// Add additional code
//SOURCE: https://system.netsuite.com/app/help/helpcenter.nl?fid=section_159008612821.html