Build a custom metric for Jira with Jira Query Language (JQL)
JQL stands for Jira Query Language. It is very similar to SQL. It is used in Jira to perform advanced searches. You can use JQL to pull Jira data and build a custom metric in Jama Analyze. You can also upload multiple JQL queries. To build a custom JQL metric:
- Add Jira as a data source.
- Select Integrations in the left panel, select Jira, and choose Custom JQL metric from the list of templates.
- Enter the name and description for this new metric.
- Paste the JQL query you want to use for this custom metric.
Tip: If you are not familiar with JQL queries, you can use the simple search feature in Jira to extract the JQL. Fill in the forms in the simple search feature in Jira, then select Advanced search to display the corresponding JQL query. You can copy and paste that JQL into Jama Analyze.
- Select Sum issue by count if you want a simple count of the issues returned, or select Sum by story points if you want to return a sum of points retrieved in this query.
- Select a start date and the frequency you would like Jama Analyze to retrieve data from Jira.
- Select where you would like this new custom metric to be visible.
- You will see a preview of the current value associated with your JQL. If this number is not what you suspect, review your JQL expression. Select Submit.