The attribute "filterRowsIgnoreCase" shows or hides rows, just as "filterRows" does. However, this function ignores the case when trying to find a pattern match.


setValue(string shape, "filterRowsIgnoreCase", dyn_string columns, dyn_string patterns, bool show);

shape.filterRowsIgnoreCase(dyn_string columns, dyn_string patterns, bool show);


Parameter Description
shape Name of the object
columns Array of column names
patterns Array of patterns. Syntax like patternMatch().

TRUE = Show row.

FALSE = Hide row.


As for "filterRows", the parameter columns holds an array of column names and the parameter patterns an equally long array of patterns (that use the syntax of patternMatch()).

All cells of the given columns in all rows of the table are checked against the pattern for the column. The case of the pattern is ignored for this, e.g.: a pattern of "*A*" will find cells containing "a" as well as "A". If a match has been found, the row will be either shown (show = true) or hidden (show = false) depending on the show argument.

This is a one-off action. The table does not store the filter criteria. This means that if you append new rows afterwards, these are shown irrespective of a possible pattern match before.