3 Replies Latest reply on Sep 5, 2018 9:08 PM by Zhenyu Luo

    Listagg fucntion not work in custom sql

    Zhenyu Luo

      hi ,

       

      I have following SQL works in Oracle, but not work in custom SQL. "Lables" has no values.

      Could anyone help me out? Thank you.

       

      SELECT

      AW_JIRAISSUE."REPORTER" AS "REPORTER",

      AW_JIRAISSUE."SUMMARY" AS "SUMMARY",

      LISTAGG ("AW_LABEL"."LABEL", ',') within group (order by "AW_LABEL"."LABEL") as "Labels",

      COUNT("AW_JIRAISSUE"."ID") AS "Count"

       

      FROM

      PRD_JIRA_AW_DWH."AW_JIRAISSUE" "AW_JIRAISSUE"

      JOIN "PRD_JIRA_AW_DWH"."AW_LABEL" "AW_LABEL" ON ("AW_JIRAISSUE"."ID" = "AW_LABEL"."ISSUE")

      Group By "REPORTER", "SUMMARY"