Web Services Developer's Guide → Web Services API Reference → SBM Application Web Services → Application Calls → RunReport
This service runs a specified Listing report for a user, given the proper privileges.
|auth (optional)||Auth||The Auth type supplies credentials and optionally, a host name for licensing. The userId and password can be specified with HTTP BASIC or WS-SECURITY instead.|
|queryRange (optional)||QueryRange||Enables you to specify the number of reports to return. Used to limit the number of reports that are returned.|
|report (required)||ReportIdentifier||Specifies the report to run.|
|solution (optional)||SolutionIdentifier||Specifies the solution that the report is based on.|
|project (optional)||ProjectIdentifier||Specifies the project that the report was created against.|
|table (optional)||TableIdentifier||Specifies the table that the report is based on.|
|reportCategory (optional)||ReportCategory||A broader enumeration that limits the response based on the category of report (built-in reports, application reports, reports you authored).|
|reportAccessLevel (optional)||ReportAccessLevel||An enumeration that limits the response based on the report's access level (PRIVATE, GUEST, USER, or MANAGER).|
|options||Options||Holds name value pairing for future arguments.|
RunReportResult is returned. A high-level description of the report is returned, along with a description of each column in the report. The fields used to order the results are shown as well. In the result parameter, the actual field values can be found. For more detail, see RunReportResult.
The RunReport call executes a given report, assuming you have the proper privilege. The GetReports call finds a list of available reports without actually running any of the reports themselves. In order to run one of those returned reports, use RunReport. If no fetchSize is specified in the QueryRange, up to 1000 items can be returned.
In order to run a Built-in report, you must provide either solutionID or solutionName. Since Built-in reports aren't tied to a specific application, you must provide the RunReport call with the solution ID or name (which can be found in the GetSolutionsWithUniqueName call). User-created reports (those stored in the TS_REPORTS table) do not require solutionID or solutionName. To run a user-created report, you simply need to provide the report ID (which can be obtained from the GetReports call).
The following XML is a snippet of the payload that is sent with RunReport.
<urn:RunReport> <urn:auth> <urn:userId>admin</urn:userId> <urn:password></urn:password> <urn:hostname></urn:hostname> <urn:loginAsUserId></urn:loginAsUserId> </urn:auth> <urn:queryRange> <urn:startIndex></urn:startIndex> <urn:fetchSize></urn:fetchSize> <urn:totalCount></urn:totalCount> </urn:queryRange> <urn:report> <urn:displayName>Test Listing Report</urn:displayName> <urn:id>118</urn:id> <urn:uuid>45e5b0ce-fb41-4a67-be7a-5941cdd04b90</urn:uuid> </urn:report> <urn:solution> <urn:displayName>Issue Defect Management</urn:displayName> <urn:id>2</urn:id> <urn:uuid>cea0a86c-5d74-4e12-b8d6-9d6b90186f1e</urn:uuid> <urn:uniqueName>ISSUE_DEFECT_MANAGEMENT</urn:uniqueName> <urn:tabName>IDM</urn:tabName> </urn:solution> <urn:project> <urn:displayName>Animation Pro</urn:displayName> <urn:id>6</urn:id> <urn:uuid>2ac5ef27-71da-4b07-ab7e-dddbc9c2d8c7</urn:uuid> <urn:fullyQualifiedName>Base Project||Base IDT Project|| Software Development||Animation Pro</urn:fullyQualifiedName> </urn:project> <urn:table> <urn:displayName>Issues</urn:displayName> <urn:id>1000</urn:id> <urn:uuid>dc8cd329-b430-436f-bb75-bf90008e6a50</urn:uuid> <urn:dbName>UBG_ISSUES</urn:dbName> </urn:table> <urn:reportCategory>USERREPORTS</urn:reportCategory> <urn:reportAccessLevel>GUEST</urn:reportAccessLevel> </urn:RunReport>
Copyright © 2007–2016 Serena Software, Inc. All rights reserved.