Filtering a Tabular Data Control

Besides sorting it, a Tabular
Data Control can also be filtered, meaning the data can be displayed
selectively depending on the value of the columns. For example, you may
wish to only show the first 5 students within a list of student records,
or only students with a grade of 80% or higher. The ability to control how
much information gets displayed at once in a TDC is very useful. If you're
unfamiliar with TDC in general, be sure to first read the tutorials "Introduction
to Tabular Data Control" and "Sorting a TDC."

Filtering a TDC follows the exact same procedure as
sorting it, and can be done either through the <PARAM> tag or script:

<PARAM name="Filter" value="filter string">

TDC.Filter: Read/writable property that contain
the filter string

TDC.reset(): Method that refreshes the
displayed data according to the settings of a Sort or Filter request.

A filter string can get more complex than a sort string,
as it supports basic logic, such as "grades that are 80% or higher" or
"names that being with John". Below lists the logic supported in a filter
string:

= (equal sign)

<> (not equal)

& (and)

> (greater than)

>= (greater or equal)

| (or)

< (less than)

<= (less than or equal)

(...) (parentheses for grouping multiple
statements)

You can use the wildcard (*) character and empty string
(&quot;&quot;) in your comparison to denote any string and empty string,
respectively. Ok you're dying to see some examples.