This article lists all of the objects and fields related to ideation in the communities data lake.
content_idea_status_changed (fact)
This object table contains a list of fields related to when an idea status is changed.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| category_id | string | refers to the unique identifier assigned to a specific category within the community |
| idea_status_id | string | refers to the unique identifier assigned to a specific idea status |
content_ideation_status_created (fact)
This object table contains a list of fields related to when ideation status is created.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| idea_status_id | string | refers to the unique identifier assigned to a specific idea status |
| idea_status_name | string | refers to the label indicating the current stage of an idea in its lifecycle |
| background_color | string | refers to the specific background color assigned to visually distinguish different statuses of ideas |
| text_color | string | refers to a specific color associated with the status of an idea |
| default | string | indicates whether a particular idea status is the default choice within the community |
| visible | string | indicates whether a status is visible to users within the community |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_ideation_status_edited (fact)
This object table contains a list of fields related to when ideation status is edited.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| idea_status_id | string | refers to the unique identifier assigned to a specific idea status |
| old_idea_status_name | string | refers to the previous label indicating the current stage of an idea in its lifecycle |
| new_idea_status_name | string | refers to the new label indicating the current stage of an idea in its lifecycle |
| old_background_color | string | refers to the previous background color assigned to visually distinguish different statuses of ideas |
| new_background_color | string | refers to the new background color assigned to visually distinguish different statuses of ideas |
| old_text_color | string | refers to the previous color associated with the status of an idea |
| new_text_color | string | refers to the new color associated with the status of an idea |
| old_default | string | indicates whether a particular idea status was the default choice within the community |
| new_default | string | indicates whether a particular idea status is the default choice within the community |
| old_visible | string | indicates whether a status was visible to users within the community |
| new_visible | string | indicates whether a status is visible to users within the community |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_ideation_status_type_changed (fact)
This object table contains a list of fields related to when ideation status is type is changed.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| idea_status_id | string | refers to the unique identifier assigned to a specific idea status |
| type | string | indicates the status of the idea, specifying whether it is categorized as open, closed, or delivered |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_unvoted (fact)
This object table contains a list of fields related to when the user remove his/her vote of an idea.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| author_id | string | refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community |
| vote_set | string | Collection of user unique identifiers (user_ids) representing users who voted for the idea |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_voted (fact)
This object table contains a list of fields related to when the user upvote an idea.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| author_id | string | refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community |
| vote_set | string | Collection of user unique identifiers (user_ids) representing users who voted for the idea |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_votes_merged (fact)
This object table contains a list of fields related to when votes of two ideas are merged.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| author_id | string | refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| source_topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| source_topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| vote_set | string | Collection of user unique identifiers (user_ids) representing users who voted for the idea |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
content_topic_votes_reset (fact)
This object table contains a list of fields related to when the count of the idea that was merged are set to zero.
| Field Name | Field Type | Field Description |
|---|---|---|
| community_id | string | contains the community ID where the activity was executed |
| correlation_id | string | refers to a unique identifier used to correlate and track related actions within the community platform, used for debugging or monitoring purposes |
| occurred_at | string | refers to the timestamp indicating the precise moment when the activity took place |
| executed_by | string | identifies the person who executed the activity (zero, if system event) |
| user_id | string | refers to the unique identifier of the person that identifies the user platform-wide |
| author_id | string | refers to unique identifier of the user who created a piece of content, topic, reply, or event, identifying the original creator within the community |
| topic_private_id | string | refers to the unique identifier of the topic, that identifies the opening topic within the Content Type |
| topic_public_id | string | refers to the unique identifier of the topic that identifies the opening topic platform-wide |
| content_type | string | Identifies the type of content, such as article, product update, question, idea, discussion |
idea_status (dimension)
This object table contains a catalog of idea statuses defined in the community with their types, ids, names and visual details.
| Field Name | Field Type | Field Description |
|---|---|---|
| idea_status_id | string | refers to the unique identifier assigned to a specific idea status |
| txt_color | string | refers to a specific color associated with the status of an idea |
| bgr_color | string | refers to the specific background color assigned to visually distinguish different statuses of ideas |
| visible | boolean | indicates whether a status is visible to users within the community |
| name | string | refers to the label indicating the current stage of an idea in its lifecycle |
| ideation_type | string | refers to the type assigned to an ideations status It can have one from the following values: open, closed, delivered |
| is_default | boolean | indicates whether a status is the default choice within the community |