JDBC Driver for Oracle SCM

Build 22.0.8462

Ideas

The Ideas resource gets the details about an idea. An idea represents a suggestion to improve a product or a process, or it could represent a suggestion to launch a new product or a new process.

Columns

Name Type Description
IdeaId [KEY] String 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 Long Total number of users that have voted Yes.
NoVoteCnt Long Total number of users that have voted No.
LikeIt Long Value that indicates the number of users who have liked the idea.
ReferencesCnt Long 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 Long 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 Long Total number of comments on the idea.
Customers String Customers of Ideas
CommentsCount Long CommentsCount of Ideas
LikeCount Long LikeCount of Ideas
DisLikeCount Long DisLikeCount of Ideas

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462