You can use several simple query operators to define query criteria.
Note: Query operators are reserved in Siebel query language. If you enter a query value that includes a query operator, then you must enclose the query value in double quotes. For example, a query for records containing the text call is closed fails. The word IS falls into the category of reserved Siebel query language because it is used in the query operators IS NULL, IS NOT NULL, and so on. If you enclose the text call is closed in double quotes ("call is closed"), then the Siebel application returns all records containing the text call is closed. Other reserved operators include apostrophe ('), brackets ( [ ] ), comma (,), parentheses (()), tilde (~), and comparison operators such as =, <, and >. |
Table: Simple Query Operators shows simple query operators. In this table, operators appear in uppercase. However, query strings are case-sensitive. The operators do not have to be in uppercase.
You can use simple query operators on their own.
Table 6-2 Simple Query Operators
Operator | Description | Example |
---|---|---|
* |
Wildcard operator. Placed anywhere in a string, returns records containing the string or containing the string plus any additional characters, including a space, that appear at the location of the asterisk. You cannot use an asterisk to find dates. To find words on more than one line in a field, you must use an asterisk to separate the words. You cannot query for control characters or non-printable characters, such as line feeds (LF) or carriage returns (CR). |
If performance is poor when you use the asterisk, then substitute "IS NOT NULL" in the query field. This substitution often improves performance. |
? |
Wildcard operator. Placed anywhere in a string, returns records containing the characters in the string plus any one additional character that appears at the location of the question mark. |
|
"" |
Placed before and after a string, returns records that exactly match the string, unless modified by a wildcard operator (* or ?). Quotes find a group of words in the exact order with the exact uppercase or lowercase lettering. |
|
= |
Placed before a value, returns records containing a value equal to the query value. |
For CIAI-enabled fields, if you type "=abc*", then the query becomes a case-sensitive query because you use an equal sign (=) as an operator in the query. |
< |
Placed before a value, returns records containing a value less than the query value. |
|
> |
Placed before a value, returns records containing a value greater than the query value. |
|
<> |
Placed before the value, returns records containing a value that is not equal to the query value. |
|
<= |
Placed before a value, returns records containing a value less than or equal to the query value. |
|
>= |
Placed before a value, returns records containing a value greater than or equal to the query value. |
|
NOT LIKE, not like |
Placed before a value, returns records not containing the value. |
|
IS NULL, is null |
Placed in the query field, returns records for which the query field is blank. |
|
IS NOT NULL, is not null |
Placed in the query field, returns records for which the query field is not blank. |
|
~ |
Placed before LIKE and a value with a wildcard operator, returns all matching records regardless of case. |
You can enter a CIAI query expression for a contact as follows: [Last Name] ~Like abc* |