Search for tickets with a specific form attached.

Question

Hello everyone,

My company has created an escalation form that can be attached to tickets that need to escalate from a tier 2 to tier 3 team. The form asks several specific questions that need answered for an escalation to be allowed and then when submitted tigers automation on the back end to alert the team your escalating to.

What i am looking for, is a JQL or search of some kind to report how many tickets have the escalation form attached. We have multiple other forms that can be attached to tickets so just searching for any ticket with an attached form will not work. I need to look for how many tickets have this specific form attached.

Is there a way to do this?

Trudy P Claspill · Answer

To be clear, you have to search for the issues based on some criteria like the "Total Forms" mentioned in the link in my first reply. Then you would have to iterate over the results set using API calls to determine if any of the forms attached are the form of interest.

You could use an Automation Rule to search for the issues with a JQL. You might do that with a JQL in a Scheduled trigger.

Then you would could use the Send Web Request action in the Automation Rule to execute calls to the REST API as needed (more than one may be needed) to look at the attached forms to see if the one of interest is present.

Executing a search with Google for jira rest api for forms  yields this as the first result:

https://developer.atlassian.com/cloud/forms/rest/intro/#about

That includes the API endpoints for getting information about Forms, and about Forms attached to issues.

If you want to create a solution that is entirely code rather than Automation, then you would use endpoints in the Jira Cloud Platform REST API to search for issues.

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-search/#api-group-issue-search

Jeremy Wood · Answer

That makes sense. Any chance you have some documentation on how i might search for the tickets using the RESP API?

Trudy P Claspill · Answer

If this is going to be an ongoing need I recommend you implement an automation to set a more easily JQL-searchable field when the form is attached to an item.

And if you need to get the same information from pre-existing issues, I recommend a solution to go through the issues and use the REST API to assess if the form of interest is attached, and then set that more easily JQL-searchable field.