Journeysevents
Journeysevents
Columns
Name | Type | Description |
JourneysJourneyId [KEY] | Long | Finds all journey templates that match the primary key specified. |
JourneyEventId [KEY] | Long | Unique identifier of the journey event. |
Category | String | Category code for the event. Values are from ORA_PER_ONB_CONTENT_SBTYP_EVNT lookup. For example, Insight. |
CategoryMeaning | String | Meaning of the event category meaning. For example, Insight. |
Sequence | Int | Task display ordering sequence. Default is 1. |
Description | String | Description of the task. |
EventURL | String | URL of the event. |
ImageURL | String | URL of the event background image. |
Title | String | Title of the event. |
EventDate | String | Date of the event. |
EventOffset | Int | Offset duration of the event. |
CreatedBy | String | User who created the event. |
CreationDate | Datetime | Date the event was created. |
LastUpdatedBy | String | User who last updated the event. |
LastUpdateDate | Datetime | Date the event 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 |