Ideas
Ideas
Columns
| Name | Type | Description |
| IdeaId [KEY] | Long | Value that uniquely identifies an idea. |
| Type | String | Value that indicates the type of idea. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Product Idea Classes task. |
| TypeDisplayValue | String | TypeDisplayValue of Ideas |
| Name | String | Name of the idea. |
| IdeaNumber | String | IdeaNumber of Ideas |
| CreatedBy | String | CreatedBy of Ideas |
| ObjectVersionNumber | Int | Number that identifies the version of the record in the database. |
| CreationDate | Datetime | CreationDate of Ideas |
| LastUpdateDate | Datetime | LastUpdateDate of Ideas |
| LastUpdatedBy | String | LastUpdatedBy of Ideas |
| Status | String | Status of the idea. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Product Idea Statuses task. |
| StatusDisplayValue | String | StatusDisplayValue of Ideas |
| LastUpdateLogin | String | LastUpdateLogin of Ideas |
| VoteSummaryAsText | String | VoteSummaryAsText of Ideas |
| AllowAccesstoEveryone | String | Contains one of the following values: true or false. If true, then access is allowed for all users. If false, then access is not allowed for all users. The default value is false. |
| Description | String | Description of the idea. |
| Content | String | Detailed description of the idea along with pictures and images. |
| Tags | String | Tags of Ideas |
| YesVoteCnt | Int | Total number of users that have voted Yes. |
| NoVoteCnt | Int | Total number of users that have voted No. |
| LikeIt | Int | Value that indicates the number of users who have liked the idea. |
| ReferencesCnt | Int | Value that indicates the count of references for an idea. The references to an idea are typically other objects that are linked to this idea. |
| Popularity | Int | Value that indicates the popularity of the idea. |
| HasMyVote | Bool | Contains one of the following values: true or false. If true, then the user has voted in favor of the idea. If false, then the user has not voted in favor of the idea. The default value is false. |
| CommentsCnt | Int | Total number of comments on the idea. |
| Customers | String | Customers of Ideas |
| CommentsCount | Int | CommentsCount of Ideas |
| LikeCount | Int | LikeCount of Ideas |
| DisLikeCount | Int | DisLikeCount of Ideas |
| ProjectedMarketDemand_c | String | ProjectedMarketDemand_c of Ideas |
| CompetitiveThreat_c | String | CompetitiveThreat_c of Ideas |
| ProjectedDevelopmentLOE_c | String | ProjectedDevelopmentLOE_c of Ideas |
| ProjectedMarketSize_c | String | ProjectedMarketSize_c of Ideas |
| StrategicFitWithBrandPortfolio_c | String | StrategicFitWithBrandPortfolio_c of Ideas |
| ProjectedRevenue_c | String | ProjectedRevenue_c of Ideas |
| IdeaPreliminaryRanking_c | String | IdeaPreliminaryRanking_c of Ideas |
| BusinessNeed_c | String | BusinessNeed_c of Ideas |
| PotentialCustomers_c | String | PotentialCustomers_c of Ideas |
| CreatorIdeaDescription_c | String | CreatorIdeaDescription_c of Ideas |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description |
| Finder | String | finder |