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 |