BTech Support

866-647-5200
Login

CMiC Query and Operators

Modified on: Wed, Nov 30 2016 9:31 AM

CMiC 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


 


Was this answer helpful?