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 |