eTag: Filter

When used with specific combinations of attributes, the Filter function lets you automate the various Filter functions available in column headers. Use the Filter action to add filters to a column referenced by its unique ID.


<Filter columnID="A0" ..../>
XML

Tag Attributes

AttributesAttribute ValuesValue DescriptionComment
TargetN/AGrid code nameN/A
RemoveTrue/FalseIf true, the filtered rows are also removed from the grid forever. The clear filter or grid reset will not bring them back. All the regular rules of filters apply regarding hierarchies, groups etc. (e.g. a filtered out parent in a hierarchy also make its children filtered out: the parent is removed from the grid, the children are removed from the grid).N/A

Detailed Description

Action parameters depend on the type of filter: The Value attribute specifies which value is to be used in the comparison process. For regular expressions filters, the expression is affected to the Regex attribute.
The Mode attribute specifies which comparison type is to be executed:

FilterMode
TextBegins
N/ANotBegins
N/AEquals
N/ANotEquals
N/ANotEquals
N/AContains
N/ANotContains
N/AEnds
N/ANotEnds



<Filter columnID="A0" Mode="Equals" Text="-Default-"/>
XML
NumberEquals
N/ANotEquals
N/AGreaterThan
N/AGreaterOrEquals
N/ALessThan
N/ALessOrEquals





<Filter columnID="I19" Mode="Equals" Number="666"/>
XML
Date & TimeEquals
N/ANotEquals
N/AAfter
N/AAfterOrEquals
N/ABefore
N/ABeforeOrEquals
N/ALastFrom

<Filter columnID="I19" Mode="Equals" Date="2011-01-01"/>
XML
<Filter columnID="I19" Mode="Equals" Time="14:15:12"/>
XML



Cut-off filters:

Possible values:

  • Years
  • Months
  • Days
  • Hours
  • Minutes

<Filter columnID="D1" Mode="LastFrom" Days="3" Hours="12" />
XML
ValueAny Value (Case sensitive)
ValueExcludedAny value (case insensitive) to remove from the filters
v18 / sapio365
Separate multiple values with a colon
<Filter columnID="D0" Value="LAEC:testcookies"/>
XML
<Filter columnID="D0" ValueExcluded="LAEC:testcookies"/>
XML






NOTEThe only way to filter a check box column is to use the Value filter set to either True or False (the default string renditions of check box fields when copying data into the windows clipboard):
<Filter columnID="D6" Value="True"/>
XML
RegexExpression
CashSensitiveTrue/False



<Filter columnID="D1" Regex="MuGre" CaseSensitive="false"/>
XML


Filter Out Empty Cells

Empty: True or False

V 16. only



<Filter columnID="D1"Empty="true"/>
XML


Example Script

To definitively remove the rows:

<Filter columnID="A0" .... Remove="True"/>
XML



In sapio365 OneDrive:

<Filter columnID="OBJECTTYPE" Value="Folder"/>
XML