OneList reports are implemented using SQL stored procedures.
Input parameters
The stored procedure must have these input parameters no matter they are used in the reporting logic.
Parameter | Nullable | Description |
---|---|---|
@startDate datetime | No | The start date of the reporting period. |
@enddate datetime | No | The end date of the reporting period. |
@categories nvarchar(max) | Yes | Selected category list separated by comma, e.g. 'Salesforce Opportunities', 'Purchase Orders' |
@users nvarchar(max) | Yes | Selected user names separated by comma, e.g. 'Approver1', 'Approver2' |
@platforms nvarchar(max) | Yes | Selected task action platform list separated by comma, e.g. 'Web', 'Mobile' |
Extended properties
The following two extended properties are required for the stored procedure to be selected for reporting:
- Description;
- Purpose: must be one of the following
- UsageReport - the stored procedure must implement the chartable report specification below;
- Export - export only, the stored procedure can produce any result table.
Chartable report specification
For on-screen chart, the stored procedure must produce the following two tables in the order as result:
...