Advanced Search

Top  Previous  Next

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:

d= DAY
M=Month
y=Year

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.