The Report View: Query Builder screen is displayed when you select the Detailed Report option in the Report Type drop down and click on Proceed>>. This screen is used to build a query condition to select the workflow for viewing the report. After specifying the query condition you must click the Show Report button to view the Detailed Report in the Report View: Report Data View screen.

The Query Builder screen has three main parts. The header fields at the top showing general information like Application Name, Workflow Name and Report Type is the first part. These fields show values that are set in the Report control properties.

The second part is the Query condition builder consisting of fields and dropdowns with numerous options to choose from for building a query. This part also has a field to view the newly built query as well as buttons to add and clear query conditions.

The links and buttons to access other screens constitute the third part of the screen. This includes the Back to Report Filter link at the top of the screen, which closes this screen and opens the previous screen i.e. the Report Filter screen. In addition it has the View Sql Query and Show Report buttons. These elements are described below.

Query Builder Screen

Query condition builder –

The Query condition builder has the following elements that are used to create a query condition to select the workflow to view reports for.

Search By Saved Report Set

This dropdown allows you to select a Report Set i.e. a query condition that was saved earlier. You can select an option here and click the Show Report button to view the detailed report.

Query On 

This drop down allows you to select a parameter to base your query on. The options include Workflow, Submitted by etc.

Operators 

This dropdown has a list of numeric, string and Boolean operators to use in constructing the query condition. The number and type of operators vary depending on the parameter chosen in the Query On dropdown.

Fields

This dropdown has a list of field types to use in the query condition.

Value

The display in this column varies depending on the selection in the previous drop down. For instance, if you select Workflow in the Query On dropdown and also in the Fields dropdown, then this column will have a dropdown with the available workflows. On the other hand, if you select Submitted By in Query On and Resource in Fields, then Values will show a chiclet button- . This button opens a popup window in which you can build a query for selecting resource(s).

Condition

This dropdown has a list of condition operators to be used to mark the end of the query condition or connect several conditions into a compound condition. For example, you can select And to add another simple condition to the first one. Or, you could end the condition by selecting the End option to close the query condition.

Add

This button adds the newly created query condition to the display field.

Undo

This button allows you to undo the previous action. It is useful when you need to correct a newly added query condition.

Clear

This button clears the query condition in the display field.

Save Report Set

This button saves the newly created condition as a Report Set, which will be added to the Search By Saved Set dropdown.

View Sql Query –

The View Sql Query button opens the window shown here with the actual database query behind the query condition that is built in the Query Builder.

View SQL Query Screen

Top

Show Report –

The Show Report button opens the Report View: Report Data View screen, which is the Detailed Report screen. The Report shows detailed information on workflow execution corresponding to the specified query condition.

Top