List View Filtering

 

 

 

Generally a ListView type view element supports advanced filtering expressions using the wild card character set "!, *, ?".

 

Using these special filtering characters allows you to filter the data to a particular subset.

 

 

Wildcards are represented by "*" or "?", where "*" matches multiple characters and "?" matches only a single character.  The special character "!" negates the result of the text search.  You can also use the "|" pipe character to form a logical OR condition.  For example, let's assume the DataView has the following items.

 

 

2FC100

2FC200

2LC120

2FY200FC

LOG2345MP

LOG2345

MP2345LOG

 

The following filters will produce the following results.

 

Command

Filter	Result
FC	Will return 2FC100,2FC200,2FY200FC
!FC	Will return LOG2345MP,LOG2345,MP2345LOG
!LOG	Will return 2FC100,2FC200,2FY200FC
*MP	Will return LOG2345MP
MP*LOG	Will return MP2345LOG
?FC???	Will return 2FC100,2FC200
LOG*	Will return LOG2345MP,LOG2345
!LOG*	Will return 2FC100,2FC200,2FY200FC,MP2345LOG
?F[CF]	Will return 2FC100, 2FF100, 9FF100, but will not return 2FT100
?L|?F	Will return any tags that have either the character 'L' OR 'F' in the second character position {2FC100,2FC200,2LC120}