Journeystasks
Journeystasks
Columns
Name | Type | Description |
JourneysJourneyId [KEY] | Long | Finds all journey templates that match the primary key specified. |
JourneyTaskId [KEY] | Long | Unique identifier of the journey task. |
Name | String | Name of the journey task. |
TaskCode | String | Code of a task in a journey template. |
Type | String | Task action type code. |
TypeMeaning | String | Task action type. |
SubType | String | Task action subtype code. Available only for action types I-9 and Electronic Signature. |
SubTypeMeaning | String | Task action subtype. Available only for action types I9 and Electronic Signature. |
RequiredFlag | Bool | Indicates whether the task is mandatory or optional. Valid values are Yes and No. Default is No. |
Status | String | Code for the task status. |
StatusMeaning | String | Status of the task. |
Sequence | Int | Task display ordering sequence. Default is 1. |
DependentTaskId | Long | Primary key or unique identifier of the dependent task. |
DependentTaskName | String | Name of the dependent task. |
TaskGroupId | Long | Unique identifier of the journey task group. |
TargetDuration | Int | Target duration for the task. |
TargetDurationUOM | String | Unit of measure for the target duration. |
TargetDurationUOMMeaning | String | Meaning of the unit of measure used in the target duration. |
DelayDuration | Int | Delay duration for the task. |
DelayDurationUOM | String | Unit of measure used in specifying delaying the duration. |
DelayDurationUOMMeaning | String | Meaning of unit of measure used in delay duration. |
Description | String | Description of the task. |
Notes | String | Notes for the task. The notes text is stored as a CLOB object. To use in the payload, the text should be converted to a base64 encoded string using either a conversion tool or a prerequisite script. |
AllowNoteTitleFlag | Bool | Indicates whether the Notes title can be added. Valid values are Yes or No. The default is No. |
AllowCommentFlag | Bool | Indicates whether comments can be added to the task. Valid values are Yes or No. The default is No. |
AllowAttachmentFlag | Bool | Indicates whether attachments can be added to the task. Valid values are Yes or No. The default is No. |
NoteTitle | String | Title of the notes. |
ActionURL | String | The URL associated with the task that's entered on the setup screen. To retrieve a navigable URL, use the getNavigationURL custom method of the resource. |
PerformerType | String | Task performer type. |
PerformerTypeMeaning | String | Task performer type meaning. |
PerformerResponsibilityType | String | Responsibility type of the journey task performer. |
PerformerResponsibilityTypeMeaning | String | Responsibility type meaning of the journey task performer. |
PerformerPersonId | Long | Internal identifier of the journey task performer. |
OwnerType | String | Task owner type. |
OwnerTypeMeaning | String | Task owner type meaning. |
OwnerResponsibilityType | String | Responsibility type of the journey task owner. |
OwnerResponsibilityTypeMeaning | String | Responsibility type meaning of the journey task owner. |
OwnerPersonId | Long | Internal identifier of the journey task owner. |
AttachmentDocumentTypeId | Long | Description for the AttachmentDocumentTypeId attribute in the tasks resource, which is part of the journeys root resource. |
AttachmentDocumentTypeName | String | Description for the AttachmentDocumentTypeName attribute in the tasks resource, which is part of the journeys root resource. |
QuestionnaireId | Long | Internal identifier of the questionnaire. |
QuestionnaireName | String | Name of the questionnaire. |
ConfigurableFormContext | String | Context for configurable form task type. |
ApplicationTask | String | Application task type. |
ApplicationTaskName | String | Name of application task type. |
ReportPath | String | Path to the report in BI Catalog. |
DigitalSignatureTemplateId | String | Identifier of the digital signature template. |
SignatureValidationConfiguration | String | Validation type for electronic signature. |
WorkAuthorizationConfiguration | String | Work authorization for I 9 task. |
ProcessCloudConfiguration | String | Configuration of the process automation. |
LearningItemId | Long | Unique identifier of the learning item. |
LearnEnrollmentId | Long | Identifier of the learning enrollment. |
LearnEnrollmentType | String | Type of learning enrollment. |
LearnCommunityId | Long | Identifier of the learning community. |
LearningContentType | String | Type of learning content. |
LearningContentTypeMeaning | String | Meaning of the learning content type. |
VideoType | String | Type of video. |
VideoTypeMeaning | String | Meaning of video type. |
VideoURL | String | URL of the video. |
AnalysisPath | String | OTBI analysis path for an analytics task type. |
AnalysisParameters | String | Parameters associated with an analytics task type. |
DisplayOptions | String | Type of OTBI analysis. |
DocumentTypeId | Long | Description for the document type identifier attribute. Identifier of the document type. |
DocumentTypeName | String | Name of the document type. |
SaveDocumentsToDORFor | String | Attachments to add to document records for a document type. |
SaveDocumentsToDORForMeaning | String | Meaning of add attachments document records. |
SaveAttachmentsToDORFor | String | Document records of person for whom to save task attachments. |
SaveAttachmentsToDORForMeaning | String | Meaning of save attachments to document records. |
EligibilityProfileId | Long | Identifier of the eligibility profile. |
EligibilityProfileName | String | Name of the eligibility profile. |
ActivationEligibilityProfileId | Long | Identifier of the eligibility profile used for the activation criteria in a journey task. |
ActivationEligibilityProfileName | String | Name of the eligibility profile used for the activation criteria in a journey task. |
EvaluationOffset | Int | Number of days to consider for eligibility evaluation. |
EnableExpiryFlag | Bool | Indicates whether the task should expire. Valid values are Yes and No. The default value is No. |
ExpiryRelativeTo | String | Criteria based on which the task expires. |
ExpiryRelativeToMeaning | String | Meaning of the criteria based on which the task expires. |
ExpiryDuration | Int | Duration after which the task expires. |
ReminderDuration | Int | Duration of the task reminder. |
ReminderRecurrence | String | Recurrence of the reminder. |
ReminderRelativeTo | String | Reminder relative to task duration. |
ReminderRelativeToMeaning | String | Meaning of reminder relative to task duration. |
ReminderTemplateId | Long | Primary key or unique identifier of the reminder notification template. |
DisplayFeatures | String | Task display features. |
AddToLibraryFlag | Bool | Indicates whether the task can be added to personal task library. Valid values are Yes or No. The default is No. |
FeedFlag | Bool | Indicates whether the atom feed is enabled for a journey task. |
InitiatedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey task is initiated. |
ReassignedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey task is reassigned. |
CompletedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey task is completed. |
DeletedFeedFlag | Bool | Indicates whether the atom feed is enabled when a journey task is deleted. |
CreatedBy | String | User who created the task. |
CreationDate | Datetime | Task creation date. |
LastUpdatedBy | String | User who last updated the task. |
LastUpdateDate | Datetime | Date on which task was last updated. |
ActionCompleteLabel | String | Setting that enables to change the label of the complete action. |
ActionRejectLabel | String | Setting that enables to change the label of the not applicable action. |
ActionAddToCalendarLabel | String | Setting that enables to change the label of the add to calendar action. |
ActionSaveLabel | String | Setting that enables to change the label of the save as draft action. |
ActivityAction1Label | String | Setting that enables to change the label of action 1. |
ActivityAction2Label | String | Setting that enables to change the label of action 2. |
ActivityAction3Label | String | Setting that enables to change the label of action 3. |
ActivityAction4Label | String | Setting that enables to change the label of action 4. |
ActivityAction5Label | String | Setting that enables to change the label of action 5. |
SourceTaskId | Long | Primary key or unique identifier of the source task. |
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 |