WorkerJourneystasksnotifications
WorkerJourneystasksnotifications
Columns
Name | Type | Description |
WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
TasksWorkerJourneyTaskId [KEY] | Long | Unique identifier of the journey task. |
WorkerJourneyTaskNotificationId [KEY] | Long | Unique identifier of the journey task notification. |
TaskEvent | String | Code of the task event. For example, task initiated, task updated, task deleted, task completed. |
TaskEventMeaning | String | Meaning of the task event. |
NotifyPerformerFlag | Bool | Indicates whether the task performer needs to be notified when the event occurs. Valid values are Yes and No. The default value is Yes. |
NotifyOwnerFlag | Bool | Indicates whether the task owner needs to be notified when the event occurs. Valid values are Yes and No. The default value is No. |
CreatedBy | String | User who created the notification. |
CreationDate | Datetime | Date on which the notification was created. |
LastUpdatedBy | String | User who last updated the notification |
LastUpdateDate | Datetime | Date on which the notification was updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
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 |
WorkerJourneyId | Long | WorkerJourneyId |
Finder | String | finder |