Once the selection process is completed, based on the options chosen the Query Report is displayed as below. Click here for more information on the Query Report Creation process.
A query report is used to create a sophisticated and very flexible report that contains only the user specified input variables and output results. Input variables are accessed thorough pre-defined DB queries and the output results are accessed using pre-defined output relates. More than one output relate could be created and used to build a query report thus offering the flexibility to combine output results corresponding to different modeling scenarios, different report time instants, etc. Query report has some similarity with customized report. However, unlike a customized report, a query report accesses inputs through DB queries and outputs through output relates. Because of this, query report offers much more flexibility to construct a sophisticated and highly customized report that meets the users interest.
Query Report Box
A query report is used to selectively choose which input and output data will appear in a report. However, unlike a customized report, a query report is required to relate data from an Output Relate with output data in a report format. Click here for more information on the Query Report Creation process.
Source Query ID
The Source Query ID is a DB Query in which a query statement is provided by the user to refine the database search during a query report (ex. show only those pipes > 8"). As part of a DB Query, the user can also create and assign an Output Relate. When an Output Relate is assigned to a DB Query, then anytime a simulation is run, the output relate tied to that DB Query will also be updated (as long as the Auto Update Relate is turned on), thus ensuring that when a query report is made, the most recent simulation results are also available for the query report.
All - All elements in the InfoWater project (depending on which element selected by the user).
Domain - By selecting domain, a query report will only be created for those elements added to a domain.
DB Query - The user can also select or create a DB Query for which a query report is to be created.
Lists all available fields that have not yet been chosen for inclusion on the query report. If a field has already been selected, it will appear in the Display Fields list to the right of the Available Fields list. Only those fields associated with the selected data categories in step 1 will be available for selection.
Lists all fields selected for inclusion on the query report. The fields will be displayed in the order that they appear in the Display Fields list. The field listed at the top is displayed first in the output report while the field listed at the bottom of the Display Fields list is displayed at the end of the query report. Use the Move Up or Move Down buttons to set the field display order.
The display buttons allow the user to add, remove, save, open and alter the order in which the query report will be created.
Add Single Field - To use this icon, select one record from the available fields box, click the Add Single Field icon and the field is now added to the query report.
Remove Single Field - To use this icon, select one record from the display fields box, click the Remove Single Field icon and the field is now removed from the query report.
Add All Fields - When this icon is used, all fields from the available fields box will be moved to the display fields box.
Remove All Fields - When this icon is used, all fields from the display fields box will be removed from inclusion in the query report.
Open - This icon will open a previously saved field collection table. This is a time saving feature that allows the user to create a query report only once to be later recalled by the open feature.
Move Up - Use this to move the display fields up in the display order.
Move Down - Use this to move the display fields down in the display order.
Once the OK button is clicked, a query report is created.
Click on cancel to exit out of the Query Report dialog box.
Query Report Methodology
Like a customized report, a query report is used to selectively choose which input and output data will appear in a report. However, unlike a customized report, a query report is required to relate data from an Output Relate with output data in a report format. In other words, the only way to see output data in a report format is to create a query report that contains a desired output relate.
Do the following to create a Query Report -
- Run a Hydraulic Simulation - Using the Run Manager, run either a steady-state or EPS simulation.
- Generate Query Statement using an Output Relate - Open the DB Query Manager under the InfoWater Browser -> Operation tab and create a new query, querying your Output Relate. For instance an Output Relate for Junctions and a DB Query identifying junctions with pressure < 35 psi may form a good combination. Click here for more information on Querying Output Relates.
- From the InfoWater Model Explorer > Command Center Tab > Tools, select the Query Report Manager command. This launches the Query Report dialog box.
- From the Source Query ID, select the appropriate database query.
- The Available Fields box will show all of the fields available from the output relate while the Display Fields box shows which fields will be included in the query report.
- Use the Display buttons to add and remove fields from inclusion in the output report.
- When all desired fields have been added to the Display Fields box, click OK and the Query Report will be generated.
- Review and print report as desired.