WorkerJourneysproperties
WorkerJourneysproperties
Columns
| Name | Type | Description |
| WorkerJourneysWorkerJourneyId [KEY] | Long | Unique identifier of the journey. |
| Code [KEY] | String | Code of the journey template property |
| Name | String | Name of the journey template property. |
| Category | String | Name of the group for journey template property. |
| CategoryMeaning | String | Meaning of the group for journey template property. |
| Level | String | Level of the journey template property. |
| DisabledForAssigneeFlag | Bool | Indicates if the journey template property is disabled for assignee. |
| DisabledForLineManagerFlag | Bool | Indicates if journey template property is disabled for line manager. |
| DisabledForOthersFlag | Bool | Indicates if the journey template is disabled for other users. |
| DisabledForInitiatorFlag | Bool | Indicates if journey template property is disabled for initiator. |
| AssigneeLookupType | String | Journey template property type for assignee. |
| LineManagerLookupType | String | Journey template property type for line manager. |
| OthersLookupType | String | Journey template property type for assignee. |
| InitiatorLookupType | String | Journey template property type for initiator. |
| AssigneeDefaultValue | String | Default value of the journey template property for assignee. |
| LineManagerDefaultValue | String | Default value of the journey template property for line manager. |
| OthersDefaultValue | String | Default value of the journey template property for other user. |
| InitiatorDefaultValue | String | Default value of the journey template property for initiator. |
| OverriddenFlag | Bool | Indicates if the journey template property is overridden. |
| AssigneeValue | String | Value of the journey template property for assignee. |
| LineManagerValue | String | Value of the journey template property for assignee. |
| OthersValue | String | Value of the journey template property for other user. |
| InitiatorValue | String | Value of the journey template property for initiator. |
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 |