Simple Query Window

<< Click to Display Table of Contents >>

Navigation:  Using Cimera > Searching and Querying >

Simple Query Window

Previous pageReturn to chapter overviewNext page

The Simple Query Window uses a single condition to find items of a single Item Type.

 

It is launched by right-clicking an Item Type in the Item Explorer Window's Item Types Navigation Pane and selecting Simple Query in New Window

 

If your administrator has disabled listing certain Item Types - as there may be lots of them and retrieving a few thousand items from the server is time consuming, requires server effort and is unlikely to be useful (what would a user do with a list of several thousand items?) - then when selecting (left-clicking) an Item Type in Item Explorer it will replace the normal list with a pane containing a Simple Query.

 

Query - Simple - Launching

 

The Simply Query only searches for items of the Item Type specified by the context of where it was called from, in the example above, a Technical Change.

 

 

Example of a Simple Query

 

Query - Simple - ER

 

Criteria

 

The criteria has 3 parts.

1.The Attribute to search against,
2.an operator: equals, contains, starts with, ends with, >, <, <>, >=, <=, in list, is null, is not null
3.the value to compare against.

 

The Attribute Type of the attribute chosen will determine which operators are appropriate and the format of the values.

 

For example.

If the Attribute is a Status then the value will be a list of possible Statuses for an item of that Item Type and inappropriate operators will be removed.
If the Attribute is a date then a date picker will be given
If the Operator is is null then no value is required.

 

Find

 

Searches the Cimera Database for all Items of the specified Item Type that match the criteria specified

 

Advanced

 

The Advanced button launches the Query Builder Window which allows multiple, complex criteria to be specified and saved.

 

Search Results

 

A list of all items meeting the selected criteria, populated when the Find button is pressed.

The filter then affects what is displayed, it does not affect what is returned from the database and changing the filter does not re-query the database.

See Item List Filter

 

 

See Also

Query Builder Window

Item List Filter