ACN_IDEA_COMMENTS_V

Details

• Schema: FUSION

• Object owner: ACN

• Object type: VIEW

Columns

Name
IDEA_ID IDEA_COMMENT COMMENT_LAST_UPDATE_DATE

Query

SQL_Statement
SELECT IDEA_ID, SUM (CASE WHEN IDEA_COMMENT IS NOT NULL THEN 1 ELSE 0 END) AS Idea_COMMENT, MAX(LAST_UPDATE_DATE) COMMENT_LAST_UPDATE_DATE FROM ACN_IDEA_COMMENT GROUP BY idea_id