Journeystasksnotifications
Journeystasksnotifications
Columns
| Name | Type | Description |
| JourneysJourneyId [KEY] | Long | Finds all journey templates that match the primary key specified. |
| TasksJourneyTaskId [KEY] | Long | Unique identifier of the journey task. |
| JourneyTaskNotificationId [KEY] | Long | Unique identifier of the journey task notification. |
| TaskEvent | String | Code of the task event. Example, task initiated, task updated, task deleted, task completed. |
| TaskEventMeaning | String | Meaning of the task event. |
| NotifyPerformerFlag | Bool | Indicates if the task performer needs to be notified when the event occurs. Valid values are Yes and No. Default is Yes. |
| NotifyOwnerFlag | Bool | Indicates if the task owner needs to be notified when the event occurs. Valid values are Yes and No. Default is No. |
| PerformerTemplateId | Long | Primary key or unique identifier of the notification template for task performer. |
| OwnerTemplateId | Long | Primary key or unique identifier of the notification template for task owner. |
| PerformerNotApplicableTemplateId | Long | Primary key or unique identifier of the notification template when a task is marked as not applicable for task performer. |
| OwnerNotApplicableTemplateId | Long | Primary key or unique identifier of the notification template when a task is marked as not applicable for task owner. |
| PerformerExpiryTemplateId | Long | Primary key or unique identifier of the expiry notification template for task performer. |
| OwnerExpiryTemplateId | Long | Primary key or unique identifier of the expiry notification template for task owner. |
| PerformerForceCompleteTemplateId | Long | Primary key or unique identifier of the force completion notification template for task performer. |
| OwnerForceCompleteTemplateId | Long | Primary key or unique identifier of the force completion notification template for task owner. |
| 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 last updated. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| CategoryFilter | String | CategoryFilter |
| CodeFilter | String | CodeFilter |
| Context | String | Context |
| ContextualAction | String | ContextualAction |
| ExcludePersonal | String | ExcludePersonal |
| Facets | String | Facets |
| FilterAttributes | String | FilterAttributes |
| JourneyId | Long | JourneyId |
| LevelFilter | String | LevelFilter |
| SearchTerms | String | SearchTerms |
| SubCategoryFilter | String | SubCategoryFilter |
| SubjectAssignmentId | Long | SubjectAssignmentId |
| SubjectPersonId | Long | SubjectPersonId |
| Finder | String | finder |