OneList reports are implemented using SQL stored procedures.
The stored procedure must have these input parameters:
Parameter | Description |
---|---|
@startDate datetime | The start date of the reporting period. |
@enddate datetime | The end date of the reporting period. |
@categories nvarchar(max) = null | Selected category list separated by comma, e.g. 'Salesforce Opportunities', 'Purchase Orders' |
@users nvarchar(max) = null | Selected user names separated by comma, e.g. 'Approver1', 'Approver2' |