This chapter contains information about the advanced search operators you can use in the application GUI fields.
The following Table lists operators allowed in QueWeb and to which data types they apply:
Operator (Meaning)
|
String
|
Date
|
Number
|
> (Greater Than)
|
+
|
+
|
+
|
< (Less Than)
|
+
|
+
|
+
|
>= (Greater Or Equal Than)
|
+
|
+
|
+
|
<= Less Or Equal Than
|
+
|
+
|
+
|
! (Not Equal)
|
+
|
+
|
+
|
= (Exact Match)
|
+
|
|
|
& (Logical AND)
|
+
|
+
|
+
|
| (Logical OR)
|
+
|
+
|
+
|
.. (Date Interval)
|
|
+
|
|
^nnn (search string must start with nnn )
|
+
|
|
|
$ (search results must end with nnn)
|
+
|
|
|
+ (Math Plus)
|
|
+
|
|
- (Math Minus)
|
|
|
|
* (Substitute any characters)
|
+
|
|
|
? (Substitute any number of characters; each ? represents one character)
|
+
|
|
|
@ (Case Insensitive)
|
+
|
|
|
You can set one of the following Date formats for your account:
Note: Modificators used in table:
Format
|
Examples
|
Format
|
Examples
|
d MMM yy
|
4 Jan 96
24 Jan 96
|
MM/dd/yy
|
01/04/96
12/24/96
|
d MMM yyyy
|
4 Jan 1996
24 Jan 1996
|
MM/dd/yyyy
|
01/04/1996
12/24/1996
|
dd MMM yy
|
04 Jan 96
24 Jan 96
|
MMddyy
|
010496
122496
|
dd MMM yyyy
|
04 Jan 1996
24 Jan 1996
|
MMddyyyy
|
01041996
12241996
|
dd/MM/yy
|
01/04/96
21/24/96
|
MMM d, yyyy
|
Jan 1, 1996
Jan 24, 1996
|
ddMMMyy
|
04Jan96
24Jan96
|
MMMM d yy
|
January 1 96
January 24 96
|
ddMMMyyyy
|
04Jan1996
24Jan1996
|
MMMM d yyyy
|
January 4 1996
January 24 1996
|
dMMMyy
|
4Jan96
24Jan96
|
MMMM dd yy
|
January 04 96
January 24 96
|
M/d/yy
|
1/4/96
12/24/96
|
MMMM dd yyyy
|
January 04 1996
January 24 1996
|
M/d/yyyy
|
1/4/1996
12/24/1996
|
|
|
Note: If you want to search for a reserved symbol used as an Operator then this symbol has to be enclosed in backslashes: ‘\’. For example, a user needs records with ‘AT&T’ in the name field. In this case he or she would have to type ‘AT\&\T’ in the name field.
|