Jira is a software management platform that allows you to plan and track the progress of your development teams on the road to release. This article will give you an overview of what the Jira/Grow integration offers you.
NOTE: Jira is supported by a third-party ETL called StitchData. To learn more, click here.
How to Connect
Grow connects to Jira Software Cloud. Before you get started you will need to obtain your Jira host domain, the email address used for the account you're connecting, and an API token. (Jira has information on getting the API token.) If you are not using a host domain on Atlassian.net, you'll need your full host URL.
- Log in to your Grow account and click Add Metric. Select Jira from the list of data sources, then click the Connect button.
- To connect to Jira, you will need your host domain, your username, and an API token. If you are not using a host domain on Atlassian.net, enter your full host URL.
- Once those fields are filled in click submit.
And that’s it! You are good to go.
The Jira/Grow integration has one custom report available called Issue Search. While a single report may seem limited, JQL makes it actually very dynamic. Once you select the report, a box will pull up where you can write JQL.
Examples of possible searches include current and completed issues for a given time period and issues competed by project team. The reports returned in the Grow app include filterable fields such as assignee, status, status category, created date, creator name, issue type, etc.
FAQs + Tips and Tricks
Querying Jira data using JQL
JQL stands for Jira Query Language. While it is not a database query language, is has some similarities to SQL syntax. JQL is used to create advanced searches in Jira.
The Jira/Grow integration has one custom report available called “Issue Search.” While a single report may seem limited, JQL makes it actually very dynamic. Once you select the report, a box will pull up where you can write JQL.
A basic query consists of three parts: a field, an operator, and then one or more values or functions.
A simple query might be the following: project = “TEST”. This would find all of the issues in the project called TEST.
Using these fields, keywords, and operators, you have the potential to build much more complex queries. You can also use the following help documents Jira provides on writing JQL:
- For available fields, check out this document
- For available operators, check out this document
- For available keywords, check out this document
- For available functions, check out this document
You can also read Jira’s documentation here.