Hi
I would like an automation that can send an email out if the issue created in Jira Service Management has the same custom field (Name), for any tickets raised in the last seven days with the same customer field (Name).
Most tickets for our clinicians are raised indirectly by other users, who populate the Clinician Name in the jira form (Custom Field). We want to be notified if within the last seven days, the third ticket for the same clinician has been raised.
So essentially If Custom Field = Name is the same in the last seven days for 2 more issues, that means send the escalation team an email.
How can we query this?