|
<< Click to Display Table of Contents >> Reporting DB Query |
  
|
|
<< Click to Display Table of Contents >> Reporting DB Query |
|
The Reporting DB Query uses standard SQL to run queries against the secondary reporting database.
The Reporting DB Query has 2 sections
| • | Reporting DB SQL |
| • | Search Results |
Reporting DB SQL
Where the text of the query is entered. Use /* and */ to delimit any comments. To comment out a single line use -- at the start of the line.
Search Results
When the query is executed the results are displayed in a Grid or a Chart
Executing SQL
SQL can be executed in 3 ways
| • | Click Menu Run > Run to execute the SQL |
| • | Press F5 |
| • | Select a subset of the text in the SQL text box and press F5 to execute the selected subset. This is most useful when developing the SQL, especially when combined with /* comments */ |
The Reporting DB Assistant aids the construction of queries by creating all the necessary joins
If the Reporting server is not running (due to failure or simply hasn't been started) then updates will not be synchronised from the main Cimera database. If no updates have been checked for, or applied, in the last 10 minutes then a suitable warning is displayed at the bottom of the results:
