Topics   All   Mac OS X (Only)   Windows (Only)   Linux (Only, Not)   iOS (Only, Not)  
Components   Crossplatform Mac & Win   Server (Not)   Client   Old   Guides   Examples
New in version: 6.3   6.4   6.5   7.0   7.1   7.2   7.3   7.4   7.5   7.6    Statistic  

XL.Sheet.AutoFilter.SetCustomFilter

Sets the custom filter criteria.

Component Version macOS Windows Server FileMaker Cloud FileMaker iOS SDK
XL 7.3 Yes Yes Yes Yes Yes

MBS( "XL.Sheet.AutoFilter.SetCustomFilter"; bookRef; sheetIndex; FilterColumnIndex; Operator1; Value1 { ; Operator2; Value2; AndOperator } )

Parameters

Parameter Description Example value
bookRef The reference to the workbook. Please use XL.LoadBook to load a file. $ref
sheetIndex The index of the sheet. This number ranges from 0 to XL.Book.SheetCount-1. 0
FilterColumnIndex The column index of the filter.
Range from 0 to XL.Sheet.AutoFilter.ColumnSize-1.
$FilterColumn
Operator1 The operator used by the filter comparison in the first filter criteria.
Can be =, ≠, <, ≤, > or ≥
"="
Value1 value used in the first filter criteria 10
Operator2 Optional
The operator used by the filter comparison in the second filter criteria.
Can be =, ≠, <, ≤, > or ≥
"="
Value2 Optional
The value used in the second filter criteria.
"20"
AndOperator Optional
Flag indicating whether the two criterias have an "and" relationship.
Pass "And" or "Or".
"And"

Result

Returns OK or error.

Description

Sets the custom filter criteria.
Operator1: operator used by the filter comparison in the first filter criteria;
Value1: value used in the first filter criteria;
Operator2: operator used by the filter comparison in the second filter criteria;
Value2: value used in the second filter criteria;
AndOperator: Flag indicating whether the two criteria have an "and" relationship.

See also


XL.Sheet.AutoFilter.GetTop10   -   XL.Sheet.AutoFilter.SetRef

Feedback: Report problem or ask question.




Links
MBS FileMaker Plugins