invantive documentation
Invantive Support ForumsAanmelden / Inschrijven

ContentPages: Atlassian Confluence

read only

  • Catalogus: JIRA
  • Schema: Views

Kan alleen gegevens ophalen.

Tabelkolommen

De kolommen van de tabel ContentPages worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype. Voor elke vereiste kolom moet bij het invoegen en bijwerken steeds een nieuwe, niet-lege waarde worden opgegeven.

Name Datatype Label Required Marks Documentation
body_anonymous_export_view_representation varchar2
body_anonymous_export_view_value varchar2
body_atlas_doc_format_representation varchar2
body_atlas_doc_format_value varchar2
body_editor_representation varchar2
body_editor_value varchar2
body_editor2_representation varchar2
body_editor2_value varchar2
body_export_view_representation varchar2
body_export_view_value varchar2
body_storage_representation varchar2
body_storage_value varchar2
body_styled_view_representation varchar2
body_styled_view_value varchar2
body_view_representation varchar2
body_view_value varchar2
history_contributors varchar2
history_createdBy_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
history_createdBy_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
history_createdBy_active char Indicates whether the user is active.
history_createdBy_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
history_createdBy_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
history_createdBy_key varchar2 This property is no longer available and will be removed from the documentation soon
history_createdBy_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
history_createdBy_name varchar2 This property is no longer available and will be removed from the documentation soon.
history_createdBy_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
history_createdDate datetime
history_lastUpdated_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
history_lastUpdated_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
history_lastUpdated_by_active char Indicates whether the user is active.
history_lastUpdated_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
history_lastUpdated_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
history_lastUpdated_by_key varchar2 This property is no longer available and will be removed from the documentation soon
history_lastUpdated_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
history_lastUpdated_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
history_lastUpdated_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
history_lastUpdated_collaborators varchar2
history_lastUpdated_friendlyWhen varchar2
history_lastUpdated_links varchar2
history_lastUpdated_message varchar2
history_lastUpdated_minorEdit char
history_lastUpdated_number int32
history_lastUpdated_when varchar2
history_latest char
history_nextVersion_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
history_nextVersion_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
history_nextVersion_by_active char Indicates whether the user is active.
history_nextVersion_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
history_nextVersion_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
history_nextVersion_by_key varchar2 This property is no longer available and will be removed from the documentation soon
history_nextVersion_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
history_nextVersion_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
history_nextVersion_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
history_nextVersion_collaborators varchar2
history_nextVersion_friendlyWhen varchar2
history_nextVersion_links varchar2
history_nextVersion_message varchar2
history_nextVersion_minorEdit char
history_nextVersion_number int32
history_nextVersion_when varchar2
history_previousVersion_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
history_previousVersion_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
history_previousVersion_by_active char Indicates whether the user is active.
history_previousVersion_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
history_previousVersion_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
history_previousVersion_by_key varchar2 This property is no longer available and will be removed from the documentation soon
history_previousVersion_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
history_previousVersion_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
history_previousVersion_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
history_previousVersion_collaborators varchar2
history_previousVersion_friendlyWhen varchar2
history_previousVersion_links varchar2
history_previousVersion_message varchar2
history_previousVersion_minorEdit char
history_previousVersion_number int32
history_previousVersion_when varchar2
id int64
key varchar2
sce_homepage_body_anonymous_export_view_representation varchar2
sce_homepage_body_anonymous_export_view_value varchar2
sce_homepage_body_atlas_doc_format_representation varchar2
sce_homepage_body_atlas_doc_format_value varchar2
sce_homepage_body_editor_representation varchar2
sce_homepage_body_editor_value varchar2
sce_homepage_body_editor2_representation varchar2
sce_homepage_body_editor2_value varchar2
sce_homepage_body_export_view_representation varchar2
sce_homepage_body_export_view_value varchar2
sce_homepage_body_storage_representation varchar2
sce_homepage_body_storage_value varchar2
sce_homepage_body_styled_view_representation varchar2
sce_homepage_body_styled_view_value varchar2
sce_homepage_body_view_representation varchar2
sce_homepage_body_view_value varchar2
sce_homepage_history_contributors varchar2
sce_homepage_history_createdBy_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
sce_homepage_history_createdBy_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
sce_homepage_history_createdBy_active char Indicates whether the user is active.
sce_homepage_history_createdBy_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
sce_homepage_history_createdBy_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_createdBy_key varchar2 This property is no longer available and will be removed from the documentation soon
sce_homepage_history_createdBy_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_createdBy_name varchar2 This property is no longer available and will be removed from the documentation soon.
sce_homepage_history_createdBy_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_createdDate datetime
sce_homepage_history_lastUpdated_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
sce_homepage_history_lastUpdated_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
sce_homepage_history_lastUpdated_by_active char Indicates whether the user is active.
sce_homepage_history_lastUpdated_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
sce_homepage_history_lastUpdated_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_lastUpdated_by_key varchar2 This property is no longer available and will be removed from the documentation soon
sce_homepage_history_lastUpdated_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_lastUpdated_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
sce_homepage_history_lastUpdated_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_lastUpdated_collaborators varchar2
sce_homepage_history_lastUpdated_friendlyWhen varchar2
sce_homepage_history_lastUpdated_links varchar2
sce_homepage_history_lastUpdated_message varchar2
sce_homepage_history_lastUpdated_minorEdit char
sce_homepage_history_lastUpdated_number int32
sce_homepage_history_lastUpdated_when varchar2
sce_homepage_history_latest char
sce_homepage_history_nextVersion_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
sce_homepage_history_nextVersion_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
sce_homepage_history_nextVersion_by_active char Indicates whether the user is active.
sce_homepage_history_nextVersion_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
sce_homepage_history_nextVersion_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_nextVersion_by_key varchar2 This property is no longer available and will be removed from the documentation soon
sce_homepage_history_nextVersion_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_nextVersion_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
sce_homepage_history_nextVersion_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_nextVersion_collaborators varchar2
sce_homepage_history_nextVersion_friendlyWhen varchar2
sce_homepage_history_nextVersion_links varchar2
sce_homepage_history_nextVersion_message varchar2
sce_homepage_history_nextVersion_minorEdit char
sce_homepage_history_nextVersion_number int32
sce_homepage_history_nextVersion_when varchar2
sce_homepage_history_previousVersion_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
sce_homepage_history_previousVersion_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
sce_homepage_history_previousVersion_by_active char Indicates whether the user is active.
sce_homepage_history_previousVersion_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
sce_homepage_history_previousVersion_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_previousVersion_by_key varchar2 This property is no longer available and will be removed from the documentation soon
sce_homepage_history_previousVersion_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_previousVersion_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
sce_homepage_history_previousVersion_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_history_previousVersion_collaborators varchar2
sce_homepage_history_previousVersion_friendlyWhen varchar2
sce_homepage_history_previousVersion_links varchar2
sce_homepage_history_previousVersion_message varchar2
sce_homepage_history_previousVersion_minorEdit char
sce_homepage_history_previousVersion_number int32
sce_homepage_history_previousVersion_when varchar2
sce_homepage_id int64
sce_homepage_key varchar2
sce_homepage_status varchar2
sce_homepage_title varchar2
sce_homepage_type varchar2
sce_homepage_version_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
sce_homepage_version_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
sce_homepage_version_by_active char Indicates whether the user is active.
sce_homepage_version_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
sce_homepage_version_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_version_by_key varchar2 This property is no longer available and will be removed from the documentation soon
sce_homepage_version_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_version_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
sce_homepage_version_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
sce_homepage_version_collaborators varchar2
sce_homepage_version_friendlyWhen varchar2
sce_homepage_version_links varchar2
sce_homepage_version_message varchar2
sce_homepage_version_minorEdit char
sce_homepage_version_number int32
sce_homepage_version_when varchar2
sce_icon_height int32
sce_icon_isDefault char
sce_icon_path varchar2
sce_icon_width int32
sce_id int64 ID.
sce_key varchar2 Key.
sce_lookAndFeel_bordersAndDividers varchar2
sce_lookAndFeel_content_body_background varchar2
sce_lookAndFeel_content_body_backgroundColor varchar2
sce_lookAndFeel_content_body_backgroundImage varchar2
sce_lookAndFeel_content_body_backgroundSize varchar2
sce_lookAndFeel_content_body_borderRadius varchar2
sce_lookAndFeel_content_body_padding varchar2
sce_lookAndFeel_content_container_background varchar2
sce_lookAndFeel_content_container_backgroundColor varchar2
sce_lookAndFeel_content_container_backgroundImage varchar2
sce_lookAndFeel_content_container_backgroundSize varchar2
sce_lookAndFeel_content_container_borderRadius varchar2
sce_lookAndFeel_content_container_padding varchar2
sce_lookAndFeel_content_header_background varchar2
sce_lookAndFeel_content_header_backgroundColor varchar2
sce_lookAndFeel_content_header_backgroundImage varchar2
sce_lookAndFeel_content_header_backgroundSize varchar2
sce_lookAndFeel_content_header_borderRadius varchar2
sce_lookAndFeel_content_header_padding varchar2
sce_lookAndFeel_content_screen_background varchar2
sce_lookAndFeel_content_screen_backgroundColor varchar2
sce_lookAndFeel_content_screen_backgroundImage varchar2
sce_lookAndFeel_content_screen_backgroundSize varchar2
sce_lookAndFeel_content_screen_gutterBottom varchar2
sce_lookAndFeel_content_screen_gutterLeft varchar2
sce_lookAndFeel_content_screen_gutterRight varchar2
sce_lookAndFeel_content_screen_gutterTop varchar2
sce_lookAndFeel_header_backgroundColor varchar2
sce_lookAndFeel_header_button_backgroundColor varchar2
sce_lookAndFeel_header_button_color varchar2
sce_lookAndFeel_header_primaryNavigation_color varchar2
sce_lookAndFeel_header_primaryNavigation_hoverOrFocus varchar2
sce_lookAndFeel_header_search_backgroundColor varchar2
sce_lookAndFeel_header_search_color varchar2
sce_lookAndFeel_header_secondaryNavigation_color varchar2
sce_lookAndFeel_header_secondaryNavigation_hoverOrFocus varchar2
sce_lookAndFeel_headings varchar2
sce_lookAndFeel_links varchar2
sce_lookAndFeel_menus_color varchar2
sce_lookAndFeel_menus_hoverOrFocus varchar2
sce_name varchar2 Name.
sce_settings_routeOverrideEnabled char Defines whether an override for the space home should be used.This is used in conjunction with a space theme provided by an app.For example, if this property is set to true, a theme can display a page other than the space homepage when users visit the root URL for a space.This property allows apps to provide content-only theming without overriding the space home.
sce_status varchar2 Status.
sce_type varchar2 Type.
status varchar2
title varchar2
type varchar2
version_by_accountId varchar2 The account ID of the user, which uniquely identifies the user across all Atlassian products.For example, 5b10ac8d82e05b22cc7d4ef5.Required in requests.An account ID with value unknown is returned when there is missing data for a user, which only happens for deleted users.We recommend you treat this value as an error case if you need to access more information about the user.
version_by_accountType varchar2 The user account type.Can take the following values: atlassian regular Atlassian user account, app system account used for Connect applications and OAuth to represent external systems, customer Jira Service Desk account representing an external service desk
version_by_active char Indicates whether the user is active.
version_by_displayName varchar2 The display name of the user.Depending on the user’s privacy setting, this may return an alternative value.
version_by_emailAddress varchar2 The email address of the user.Depending on the user’s privacy setting, this may be returned as null.
version_by_key varchar2 This property is no longer available and will be removed from the documentation soon
version_by_locale varchar2 The locale of the user.Depending on the user’s privacy setting, this may be returned as null.
version_by_name varchar2 This property is no longer available and will be removed from the documentation soon.
version_by_timeZone varchar2 The time zone specified in the user's profile.Depending on the user’s privacy setting, this may be returned as null.
version_collaborators varchar2
version_friendlyWhen varchar2
version_links varchar2
version_message varchar2
version_minorEdit char
version_number int32
version_when varchar2