To view the Detailed Report you must first build a query in the Report View: Query Builder screen. This displays when you click on the Proceed>> link in the Report View - Master Level Selection: screen. The detailed report that is displayed corresponds to the query condition set in this screen.
You can opt to use a saved 'report set' to search for the workflows for viewing reports. The 'report set' contains a query built earlier. Select a saved 'report set' from the Search By Saved Report Set drop down.
To build a query.
1. Select a parameter to query on from the Query On drop down.
The parameters include Workflow, Version, Workflow Internal Status, Workflow User Maintained Status, Submitted By, Content Data, Workflow Executed Date Time, Action Name, Action Type, Action Status, Action Activity Status etc.
2. Next, select the operator to build the query condition from the Operators drop down.
The operators include =, <, >, <>, as well as 'In', 'Contains' etc.
3. From the Fields drop down, select the field type.
Depending on the field type selection the Value
field appears with appropriate controls to specify the value, such as data
entry fields and drop downs to enter or select the value of the query
condition. If you select Submitted By in the Query On drop down
and then select Resource in the Fields drop down, a chiclet
button -
displays in the Value column. Click on this button and build a query to
select the resources in the window that pops up.
4. After completing a query condition, click the Add button to add the query to the query condition display with the label Show reports where... . If you want to create a compound condition, after building the first condition, select a Boolean operator instead of 'End' from the Condition drop down and build the second condition. Select 'End' when your condition is complete and then click Add.
5. If you wish to make changes to the newly added condition, you can click on the Undo button to undo the last action. You can also click the Clear button to clear the condition(s) in the query condition display.
6. After building the query, you can click on the Show Report button to display the corresponding report. You can also click the View Sql Query button to view the actual query in a separate window.
Note The options available in the different Query drop downs and the queries that can be built using them are predefined in the ReportType.XML configuration file. Skelta Workflow.NET 2004 has a standard set of query blocks that are used to assemble the queries. You can change the standard query blocks or add your own query blocks to the configuration file.