![]() Make sure to sort the results in the query.įor example, to return 20000 issues, put this on one cell to return the first 10,000 issues: If you need to return more issues, you should use the =JIRA() function which lets you paginate through results. The add-on should work fine with queries of up to 10,000 issues. ![]() The add-on returns an error when I want to query a large number of issues. You will only need to do this once (we’re working on fixing a bug causing this behavior). Enter the query again and it should now work. I enabled the =JIRA() function and it's still showing me an error.Ĭlear the value of the cell where you are using the =JIRA() function, press enter. Now you can switch between sites during import. To connect an additional Jira Cloud site:Ĭlick Add-ons → Jira Cloud for Sheets → Open…Ĭlick on the dropdown next to your current site and click ‘ Add another site… ’.įollow the prompts to provide access to the add-on for the additional Jira Cloud site. For example, =JIRA( "project=XYZ AND issuetype='technical task'") will return all issues that are of issue type "technical task" in the project XYZ.Ĭonnect additional Jira Cloud sites (optional) If you want to use multiple words separated by a space in the =JIRA() function, you'll have to enclose the words with single quotes. Query =JIRA("project = ProjA", "issuekey,summary,created,reporter") Return all the issues in ProjA but only the issue key, summary text, the created time, and the reporter. Query =JIRA("project = ProjA order by createdDate desc", "issuekey,status.id,another column", 0, 10) Scenario Return the first 10 issues in ProjA but only the issue key, the internal id of the status, and a custom column with spaces in its name. Query =JIRA("project = ProjA", "issuekey,summary,created,reporter") Scenario Query =JIRA("project = ProjA and createdDate >= -7d") Scenario Return the issues in project ProjA that have been created in the last week, using your default set of columns. You can use the function from a cell in the spreadsheet: You can now import Jira issues to your spreadsheet by clicking on Get data from Jira and then using one of the following methods: Using JQLīe careful when sharing a spreadsheet with JIRA() custom function enabled as anyone who can edit it will be able to use this function and import Jira data using the document owner’s Jira account. Once the authorization is successful you’ll be redirected to your Google Sheets spreadsheet and you should see something like the following (aka the hamburger menu): Select the site you want to add from the list of available sites, and click Accept. Open a Google Sheets spreadsheet and select Add-ons → Jira Cloud for Sheets → Open…Ĭlick CONNECT, this will open a new browser window. Search for “ Jira Cloud for Sheets” then hover over the card and click +Free.įollow the prompts to give the add-on access to your Google Sheets spreadsheet. ![]() If you restrict access to your Jira Cloud instance, please add these IP addresses to your allow list. This applies to Jira for Google Sheets, Jira for Excel and the export to Google Sheets/Excel from Jira.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |