Journeysnotes
Journeysnotes
Columns
Name | Type | Description |
JourneysJourneyId [KEY] | Long | Finds all journey templates that match the primary key specified. |
JourneyNoteId [KEY] | Long | Unique identifier of the journey notes. |
Sequence | Int | Task display ordering sequence. Default is 1. |
Type | String | Note subtype code. Values are from the ORA_PER_ONB_CONTENT_SBTYP_NOTE lookup. Example, Meeting Note, Standard Note. |
TypeMeaning | String | Note subtype meaning. |
Description | String | Description of the task. |
EventDate | String | Date for meeting type note. |
EventLocation | String | Location for meeting type note. |
EventTime | String | Time for meeting type note. |
EventOffset | Int | Offset value for the event. |
Title | String | Title of the notes. |
CreatedBy | String | User who created the notes. |
CreationDate | Datetime | Date the notes was created. |
LastUpdatedBy | String | User who last updated the notes. |
LastUpdateDate | Datetime | Date the notes 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 |