Modules

filter

 

Objects/Functions

module (N/workbook)

SuiteScript 2.0

workbook.TableFilter

// 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