Akumina Flow Reports - Akumina Community

Akumina Flow Reports

How To Run Reports

Flow reports are configured in the Flow definition. The Akumina Flow User and Team widgets provide an easy to use reporting access. The Akumina Flow Owners Management Application also provides access to reports.
You can request reports directly by calling the API endpoint: POST: api/teamprocessinstance/metrics/run

Standard Parameters

The following parameters are available for all reports:

ProcessId
Required ID of process to query instances of
InstanceStatus
Optionally limit data to instances that have completed (2) or canceled (3). Note that only closed instances are available for reporting
DateCol
If filtering by date, which date do you want to use: ClosedDate or CreatedDate
DateFromUtc
Optionally filter by date range. This is the starting inclusive date range; provide in format yyyy-mm-ddThh:MM:ss.sssZ as in 2021-02-21T00:00:00.0000000Z
DateToUtc
Optionally filter by date range. This is the ending inclusive date range; provide in format yyyy-mm-ddThh:MM:ss.sssZ as in 2021-02-21T23:59:59.9999999Z
IsInstanceOwner
If set to true, will allow reporting when usage is restricted to Owners and will only return data where the current user is an instance owner
UseCache
Whether to use cached results (if exists) or force a refresh? Only report data which meets one of the checks below will be cached:

  • ReportUsage = User
  • ReportUsage = Owner and current user is a process owner (Instance owners are not supported)
CacheTimeInMinutes
If you want the report data to be cached, provide a value > 0. The number of minutes the fetched report data will be cached. The cache key ensures that only report requests that match will be returned.

Other Parameters

The following parameters are available on a report by report basis and are included under the “OptionalFilter” property:

Key
Required Property Name; this must match the property name as defined in the Flow definition.
CreatedById
Optionally limit data to instances created by this user; AAD ID for user
CurrentSiteIdWebId
Optionally limit data to instances created in the context of this site
QueryProperties
Optionally limit data by custom property values (Memo and File properties not supported). Use format: “PROPNAME1:propValue1,PROPNAME2:orValue1,PROPNAME2:orValue2”.
“propValue” can’t contain a “:” or a “,”. Use “*” for a wildcard search; e.g. “START_TIME:2022-09-16*” will return all instances with a START_TIME property value of September 16, 2022 (regardless of time of day)
PageIndex
Which page of results to return? Paging starts at 1.
PageSize
How many results to return per page?
OrderBy
How should results be ordered? Typically its either “CreatedDate ASC” or “ClosedDate DESC”
TaskId
Set scope of report to a specific Task within the Process

Reports

Report Description ID Supported Other Parameters
Choice Property Usage For each choice value found, returns Property Label (in requested language), Choice Value (in requested language) and Number of occurrences PCVUR Key (Required) The name of the choice property, CreatedById, CurrentSiteIdWebId, QueryProperties
Choice Score Returns the average score for instances that match the provided filter. The data returned includes: TotalScore, TotalCount, Score (Avg Score), ScoreLabel (Avg Score Label in requested language), Color, BackgroundColor PCSR CreatedById, CurrentSiteIdWebId, QueryProperties
Count By Status Returns the count of instances that match the provided filter grouped by instance status. The data returned includes: Status and TotalCount PCR CreatedById, CurrentSiteIdWebId, QueryProperties
Property Values Returns a page of non-null values found for the provided property in the instances that match the provided filter PPVR Key (Required) The name of the property (File Type properties are not supported), PageIndex, PageSize, OrderBy, CreatedById, CurrentSiteIdWebId, QueryProperties
Properties Values Returns a page of requested properties for instances that match the provided filter. Shares ReportUsage defined for Property Values report.  The Akumina Flow Owners Page uses this report to implement the “Properties Export” report. PPSVR PageIndex, PageSize, OrderBy, CreatedById, CurrentSiteIdWebId, QueryProperties,

PropertyNames
The names of the properties to return provided using the format: “CUSTOMPROPNAME1,CUSTOMPROPNAME2,StandardPropName1”
where standard properties include: ProcessId, ProcessType, Id (instance ID), CreatedDate, ClosedDate, CreatedById, CreatedByName, Status (2,3), CurrentSiteIdWebId, WasOverDue (0/1)
and custom properties are all properties defined in the process definition, except for File type properties.
Workflow Performance Returns TaskId (if not included in filter), TotalCount of tasks, TotalOverdue tasks, AvgAssignentTime, AvgWorkTime PWPR TaskId, CreatedById, CurrentSiteIdWebId, QueryProperties
Assignee Workflow Performance Returns TaskId (if not included in filter), AssigneeName (if not included in filter), TotalCount of tasks, TotalOverdue tasks, AvgAssignentTime, AvgWorkTime PAWPR TaskId, CreatedById, CurrentSiteIdWebId, QueryProperties,

AssigneeId
Optionally limit to a specific user; provide AAD User ID
Role Workflow Performance Returns RoleId (if not included in filter), TaskId, AssigneeName (if not included in filter), TotalCount of tasks, TotalOverdue tasks, AvgAssignentTime, AvgWorkTime PRWPR CreatedById, CurrentSiteIdWebId, QueryProperties,

RoleId
Optionally limit to a specific role
Views: 120
//]]>