Generating a Custom SQL Query Report for AdminStudio

AdminStudio Enterprise Server 11.5 | Report Center

Edition: Report Center is included with AdminStudio Enterprise Edition and with Workflow Manager.

You can generate a Custom SQL Query Report to include data generated by both AdminStudio and Workflow Manager. 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 an SQL Query to retrieve the data for this report. Click the Test Query button to verify the query syntax.

Tip: To assist you in writing queries to retrieve data, see Wildcard Support in Report Center SQL Queries.

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. Select the roles that you want to have permission to view this report.
8. Click Next. The Report Summary panel opens, which displays all the information needed to create the report.
9. Click Finish. The report is generated in the Report View. This report is also saved and now appears in the list on the All Reports page.

Wildcard Support in Report Center SQL Queries

In Report Center searches, the LIKE operator is always used. You can combine the LIKE operator with a wildcard character, and the following rules apply:

Wildcard Support in Report Center Queries

Situation

Rule

When no wildcards are used

If you do not enter a wildcard character in the Search box, then Report Center performs a “LIKE” search, which searches for any occurrence of that text anywhere in the item that is being searched for.

For example, if you are searching for a file name that has the word test anywhere in the file name, and you entered test in the Search box, it would be interpreted by Report Center as:

*test*

And the following files would be found:

MyTestFile and TestFile

When wildcards are used

You can specify a * wildcard in the Search box to narrow the search results.

For example, if you are searching for a file name that includes the word test, but does not begin with it, and you entered *test in the Search box, MyTest would be returned, but not TestFile.

Workflow Manager 6.0 / AdminStudio Enterprise Server 11.5 Help Library

June 29, 2012

 Copyright Information | Contact Us