ProForma: JQL query to find all the issues that have a FORM attached to them
Platform Notice: Cloud - This article applies to Atlassian products on the cloud platform.
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Here is a way to use JQL to get a list of issues that use FORMS and have values inside them - This JQL will give you the actual issues where Forms are being used and not just Enabled.
Environment
Jira Cloud and DC.
Solution
One can run the below JQL to find all the issues that have either a Locked, Open, Submitted or any kind of Form :
issueFormsVersion > 0
Once you run the above JQL make sure to select the following Columns "Locked Form", "Open Form", "Submitted Form" and "Total Forms" and click DONE and you should get the data from the JQL.
Please check the working of this JQL and add the columns to the result in the below video: