Generating a Custom SQL Query Report
AdminStudio 2023 | 25.0 | Reports
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. | In the navigation bar, click Create Custom SQL Query Report. The Enter SQL Query panel of the Create Custom SQL Query Report page opens. |
| 2. | 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 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.
| 3. | Click Next. The Specify general information panel opens. |
| 4. | 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. |
| 5. | Decide which roles should have the right to view your report, selecting them from the Roles tree |
| 6. | Click Next. The Save and preview report panel opens, summarizing the information that will be used to create your report. |
| 7. | Click Save and preview. Your report is generated. The report will now also appear in the list on the All Reports page. |
See Also
Wildcard Support in Reports SQL Queries