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