Generating a Custom SQL Query Report
Workflow Manager 6.0 | Report Center
Edition: This feature is available in Workflow Manager only.
A Custom SQL Query Report is a report on data generated by Workflow Manager that is defined by entering an SQL query in the Report Wizard. To generate a Custom SQL Query Report, perform the following steps.
To generate a new Custom SQL Query report:
|
1.
|
Open the Report Center tab. The All Reports page opens. |
|
2.
|
Click Add. The Select Report Type panel opens. |
|
3.
|
Click Custom SQL Query Report. The Enter SQL Query panel opens. |
|
4.
|
Enter the SQL query which is to retrieve data for your report into the Custom SQL Query text field to retrieve the data for this report. Click the Test Query button to verify the query syntax. |
Note: Refer to Enter SQL Query Panel for information about Workflow Manager database tables which you might want to return data from.
|
5.
|
Click Next. The General Information panel opens. |
|
6.
|
Enter a Report Name and Description to clearly identify the contents and purpose of this report. This name and description will be listed on the All Reports page. |
|
7.
|
Decide which roles should have the right to view your report, selecting them from the Roles tree |
|
8.
|
Click Next. The Report Summary panel opens, summarizing the information that will be used to create your report. |
|
9.
|
Click Finish. Your report is generated, and the Report View page opens, running your SQL query and displaying the results. The report will now also appear in the list on the All Reports page. |
See Also
Wildcard Support in Report Center SQL Queries
Generating and Viewing Workflow Manager Reports
Generating System Reports
Open topic with navigation