Query Filter

 

Runtime Options

 

The default comparison operator is ( = ), which searches for an exact match between the BrowseBox field and the corresponding Query input field. By default all matches are case sensitive. Pressing the comparison operator button cycles through all the available operators:

Operator

 

Filter Effect

 

=

browsefield

equal

queryvalue

>=

browsefield

greater than or equal

queryvalue

<=

browsefield

less than or equal

queryvalue

<>

browsefield

not equal

queryvalue

 

no filter

 

 

For string fields, you may use the following special characters in the Query input field to refine your search:

Symbol

Position

Filter Effect

 

 

^

prefix

caseless (case insensitive) search

 

 

*

prefix

browsefield

contains

queryvalue

*

suffix

browsefield

begins with

queryvalue

For example:

d

matches 'd' only

d*

matches 'dog', 'david'

*d

matches 'dog', 'cod'

^*d

matches 'dog', 'cod', 'coD'

Upon completion of the Query dialog, the current sort order of the BrowseBox is filtered to match the query. If Query is selected again, the previous query is available by default. This allows sharing of filters between sort orders, as well as successive filter refinements.

 

Copyright Programmed Network Management PL 2023