get_reports

This function retrieves a list of available reports for a given user.

SYNTAX

http://www.myserver.com/evj/ExtraView/ev_api.action?
user_id=username
&password=password
&statevar=get_reports

NOTES

The delimiter ‘:’ in the example is the system delimiter stored in the behavior setting named DEFAULT_TEXT_REPORT_DELIMITER.

The typical use of this command is to retrieve a list of available public and private reports, to present these as a menu and allow the user to select which report he is going to run with the run_report function.

There are two main sections returned, a list of private: and a list of public: reports.

Within each of these sections, each report is shown with four values, separated by the DEFAULT_TEXT_REPORT_DELIMITER and specified as:

1. Report ID – a numeric identifier for the report

2. Title – the title of the report

3. Type – One of the following types:

Type Purpose
ADMIN_REPORT Admin Report
ADVANCED Column report with advanced filters
AGING Aging reports with standard filters
AGING_ADV Aging reports with advanced filters
CALENDAR Calendar report with standard filters
CALENDAR_ADV Calendar report with advanced filters
CHART Charts with standard filters
CHART_ADV Charts with advanced filters
CONTAINER Container reports
CUSTOMURL Custom URL report with standard filters
CUSTOMURL_ADV Custom URL report with advanced filters
DASHBOARD Dashboard report
DETAILED Detailed reports
GEOSPATIAL Geospatial reports with standard filters
GEOSPATIAL_ADV Geospatial reports with advanced filters
MATRIX Matrix report with standard filters
MATRIX_ADV Matrix report with advanced filters
PAGE_LAYOUT_CHR Page Layout chart
PAGE_LAYOUT_COL Page Layout Column report
PAGE_LAYOUT_DGB Page Layout Double Group By report
PAGE_LAYOUT_SGB Page Layout Single Group By report
PLANNING_ADV Planning report with advanced filters
QUICKLIST QuickList reports
STANDARD Column reports with standard filters
SUMMARY Summary reports with standard filters
SUMMARY_ADV Summary reports with advanced filters
TASKBOARD Taskboard reports with standard filters
TASKBOARD_ADV Taskboard reports with advanced filters
TREEGRID Treegrid reports with standard filters
TREEGRID_ADV Treegrid reports with advanced filters

Sample return from the get_reports function:

private:
 
169:All Features Requests:STANDARD:That are open
 
94:Bugs I Fixed in January:STANDARD:Bugs not Closed Yet
 
99:Bugs Open By Month:CHART:For Tracker Enterprise
 
401:Build
 
30:STANDARD:Estimated versus Actual Time
 
89:My Hot Llist:STANDARD:Priority 1 issues that are not closed
 
73:Open and Fixed Defects:CHART:Year to Date
 
114:Owners of open bugs:STANDARD:Sorted by owner
 
119:Report of Open issues:STANDARD:By Bill
 
109:Status of Bugs Reported:CHART:Over all bugs public:
 
144:Bug Trend Report:CHART:Open vs. Fixed Issues
 
391:Bugs:AGING:Aging of all bugs that are not closed
 
4:Bugs - Assigned to you:SUMMARY:Issues assigned by product
 
164:Bugs - List of Closed Issues:STANDARD:Ordered by Product
 
68:Bugs - No Reproducible State:STANDARD:Open Issues
 
386:Customer Issues:AGING:Aging of all issues
 
43:Customer Issues:STANDARD:New Issues By Priority
 
48:Customer Issues:STANDARD:Open Issues By Priority
 
249:Customer Issues - Time Spent:STANDARD:Items fixed
 
58:Feature Requests:SUMMARY: Requests By Product and Category
 
239:Helpdesk Issues:STANDARD:New / Open Issues Assigned to Me
 
234:Helpdesk Issues:ADVANCED:Open Issues
 
209:Knowledge Base:ADVANCED:Published Articles
 
214:Knowledge Base:ADVANCED:Unpublished Articles
 
79:My Open Issues:STANDARD:for Home Page
 
33:Open P1 Issues:STANDARD:All Areas - Ordered by Assigned To
 
3:Originated by you:SUMMARY:Issues originated by you
 
63:QA List - Fixed Defects:STANDARD:Ordered by Priority
 
84:Summary of All Issues:CHART:Chart of All Statuses
 
53:Summary of Open Customer Issues:SUMMARY_ADV:By Product