|
<< Click to Display Table of Contents >> Three Types of Query |
  
|
|
<< Click to Display Table of Contents >> Three Types of Query |
|
Cimera provides three different types of structured query:
The Query Builder allows the relatively inexperienced user to build simple queries to find items matching certain criteria. These queries cannot query related items as may be performed using CQL.
CQL (Cimera Query Language) queries may be used to find a set of Items that match criteria. CQL is not as fully featured as SQL and only allows finding items. It does not allow aggregate functions (such as Average, Sum, Min, Max, Count) and it is not possible to select a subset of attributes or include attributes from related items.
So, for example, a CQL query can be used to find Problems that are Open and related to a Build that has been deployed to a UAT Server. However that query will only return matching Problems. It cannot return any attributes from the related items Build and Server.
Cimera has an interactive data dictionary that assists in the building of CQL queries.
CQL queries may contain symbolics to allow the same query to be rerun but with different parameters captured from the user running the query
The Reporting Database is a secondary SQL Server database that is constantly synchronised with the main Cimera Database. Queries are written using the full power of SQL. The background synchronisation means that at times it might be a minute or two behind the main database.
It is expected that users writing queries against the reporting database are conversant, and preferably skilled, with SQL. Cimera provides some assistance with identifying the relevant parts of the reporting database schema, and creating joins, but it does not offer assistance with the overall SQL statement.
As the reporting database is a secondary database, long running, complex or resource hungry queries will not impact other users of Cimera.
Reporting database queries may contain symbolics to allow the same query to be rerun but with different parameters captured from the user running the query
See Also