How can I create a report on Parent Ticket IDs and their respective child tickets? | Community
Skip to main content

How can I create a report on Parent Ticket IDs and their respective child tickets?

  • November 4, 2024
  • 1 reply
  • 0 views
Karan12

Simply, I'd need a row level data with the following headers:

      1 reply

      Elaine14
      • Elaine14
      • January 4, 2025
      Hi karankuwarbidxb,
       
      Good day!
       
      I see that you’re looking for a report with specific details on Parent Ticket IDs and their respective Child Ticket groups. You may follow the suggested formula given in this article to extract the Parent ID.
       
      REGEXP_EXTRACT([Ticket external ID], "^zen:side_conversation:.*:(\d+)$")
       
      Here’s how it appeared.
       

       
      I hope that helps!
      Terms & ConditionsCookie settingsAccessibility statement