WorkerJourneystaskCounts
WorkerJourneystaskCounts
Columns
Name | Type | Description |
WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
WorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
SelfTasks | Double | Count of tasks for the signed in user in the journey. |
OverdueSelfTasks | Double | Count of overdue tasks for the signed in user in the journey. |
AvailableSelfTasks | Double | Count of tasks in the journey that are active and aren't deferred for the signed in user. |
AvailableOthersTasks | Double | Count of tasks in the journey that are active and aren't deferred for users other than the signed in user. |
CompletedSelfTasks | Double | Count of tasks completed by the signed in user in the journey. |
WorkerTasks | Double | Count of assignee tasks in the journey. |
CompletedWorkerTasks | Double | Count of tasks completed by journey assignee in the journey. |
OthersTasks | Double | Count of tasks to be performed by users other than the signed in user or the journey assignee in the journey. |
CompletedOthersTasks | Double | Count of tasks to be completed by users other than the signed in user or the journey assignee in the journey. |
Tasks | Double | Total tasks in the journey. |
OverdueTasks | Double | Total number of overdue tasks in the journey. |
CompletedTasks | Double | Total number of completed tasks in the journey. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
Name | Type | Description |
AllocatedAfterDate | Date | AllocatedAfterDate |
AssignmentId | Long | AssignmentId |
CategoryFilter | String | CategoryFilter |
CodeFilter | String | CodeFilter |
Context | String | Context |
ContextualAction | String | ContextualAction |
Facets | String | Facets |
JourneyId | Long | JourneyId |
Overdue | String | Overdue |
PersonId | Long | PersonId |
SearchTerms | String | SearchTerms |
StatusCategory | String | StatusCategory |
StatusFilter | String | StatusFilter |
SubCategoryFilter | String | SubCategoryFilter |
Finder | String | finder |