ACN_IDEA_VOTE_SUMMARY_V
Details
-
Schema: FUSION
-
Object owner: ACN
-
Object type: VIEW
Columns
Name |
---|
IDEA_ID YES_COUNT NO_COUNT VOTE_LAST_UPDATE_DATE |
Query
SQL_Statement |
---|
SELECT IDEA_ID, SUM(DECODE(vote, 'Y', 1, 0 )) AS yes_count, SUM(DECODE(vote, 'N', 1, 0 )) AS no_count, MAX(LAST_UPDATE_DATE) VOTE_LAST_UPDATE_DATE FROM acn_idea_vote GROUP BY idea_id |