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.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。