Recent searches


No recent searches

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



Posted Nov 04, 2024

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


1

1

1 comment

image avatar

Elaine

Zendesk Customer Care

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!

0


Please sign in to leave a comment.

Didn't find what you're looking for?

New post