Search for tickets with a specific form attached.

[Jeremy]

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 Claspill]

Hello @Jeremy 

Welcome to that Atlassian community.

Based on this KB, it appears that there is not a method currently for searching with JQL for items that have a specific form attached.

https://confluence.atlassian.com/jirakb/find-work-items-with-attached-forms-using-jql-in-jira-cloud-1346244767.html

What do you want to do with the results of the search?

It might be possible to find such issues by using the API, which could be accessed through an Automation Rule. In that implementation there might be actions available, like sending an email or setting a searchable field in the issue, when such an issue is found.

You may want to consider using automation triggered by a form being attached to an issue to proactively set a searchable field in the item so that you have an alternate method for searching for such items.

[Jeremy Wood]

Basically just trying to start by getting a list of the tickets so we can dig into the data behind them. How often if the form being used? Is it being used correctly? Were all the questions actually answered or how many tickets did they just put "Escalation" in the text box. (I've been told his has happened but haven't been given specific tickets so trying to dig into this.) Those kinds of details. 

[Trudy Claspill]

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.

[Jeremy Wood]

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

[Trudy Claspill]

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