CMiC Query and Operators
Modified on: Wed, Nov 30 2016 9:31 AMCMiC Query and Operators
Operator |
Description |
“_” |
(Underscore) character represents a single character. |
“%” |
(Percent Sign) represents any combination of characters |
“=” |
Equal to |
“!=” |
Not equal to |
“<>” |
Not equal to |
“>” |
Greater than |
“>=” |
Greater than or equal to |
“<” |
Less than |
“<=” |
Less than or equal to |
“Between” |
Between two values |
“Not between” |
Results will be outside of the ‘not between’ values |
|
When using a date field us the date format ‘DD-MON-YY’ |
“In” |
Included in a specified list i.e. “In (‘ABC123’, ‘ACM001’)” |
“Not in” |
Not included in a specified list |
“Like” |
Similar to a specified search usually including a ‘%’ i.e. “Like ‘%tower%’ |
“Not like” |
Not similar to a specified search |
“Is null” |
The search will return records where the field is not populated with data |
“Is not null” |
The search will return records where the field is populated with data |
ADVANCED QUERY FUNCTION
In enter query mode, enter an ‘&’ and a name in each field i.e. “&DATE”, then execute the query. Enter the search criteria in the pop up window, i.e. “&DATE between ’01-JAN-07 and ’31-JAN-07’”
QUERY STEP BY STEP
To pop-up the query editor to allow for queries (such as null, between, not null):
1. Enter Query Mode <F11>
2. Type in &any character
3. Execute Query
4. Type in the query (sample above)
5. Select OK