Alpha-Numeric Querying Options
The WiSeMan System allows flexible querying on the majority of displayed fields on a screen.
The WiSeMan System uses two types of fields, Alpha-Numeric and Dates.
Alpha-Numeric Fields
Alpha-numeric fields can hold characters and/or numbers. Alpha-numeric fields can queried upon in five ways:
Type of Search
|
Wildcard Character
|
Field Entry
|
Search Result
|
|
Exact Match
|
N/A
|
Smith
|
All records with a value of Smith in the relevant field.
|
|
Wildcard Match
|
*
|
Ja*
|
All records with a value beginning with ‘Ja’, e.g. James, Jameson, Jackson, Jar, Jam, in the relevant field.
|
|
Single Character Match
|
?
|
Ja?
|
All records with a 3 character value that starts with ‘Ja’, e.g. Jar, Jam, Jan, in the relevant field.
|
|
'Not Equal' Match
|
<>
OR !=
|
!=British
|
All records with a value that isn't British in the specified field.
|
|
Blank Field Match
|
=
|
=
|
All records with nothing in the specified field.
|
