/
Fetching issues

Fetching issues

To start working on Jira data you need to Import issues from any of the saved filters (those are filters available for logged in user) or use JQL.

When fetching data from Jira, results are limited to 3000 issues.

filter.mp4

When you have data in excel, you can easily change visible columns, reducing the number of visible columns will also increase performance.

filtervisible.mp4

As you can see, even after refresh columns stay hidden.

Use schema from the selected filter

When importing from a selected filter (1)(4), you can have the connector apply that filter's column order as your worksheet schema (the visible fields and their order). Enable Use schema from the selected filter (the checkbox under the filter selector in the General tab) before importing.

Group 28.png

How to enable it

Group 30.png

  • Select a saved filter (this option is not available for JQL or default/system filters).

  • The checkbox is available only if the selected filter has a column order configured. If it does not (1), the option is greyed out (2) with the note "This filter does not have column order configured." (3)

  • Tick the checkbox (5). When available, the tooltip reads "After import, the filter's column order will be applied."

Group 31.png
Group 32 (3).png

How to use it

  • Select the saved filter you want to import from.

  • Tick Use schema from the selected filter.

  • Import issues as usual — the filter's column order is applied to the worksheet automatically, so the visible fields and their order match the filter.

How it affects schema selection

  • On import, the column order from the filter is applied— setting the visible fields and their order to match the filter.

  • If the resulting fields and order exactly match one of your saved schemas, that schema is selected automatically; otherwise the order is applied without selecting a named schema.

  • If the filter has no column order, your current schema is left unchanged.

schema.mp4

We are constantly increasing the number of available fields: Supported fields

 

Import issues will also pull metadata from projects - allowing you to create new Jira issues: Create new issue

 

At this article you can find answer for following questions:

What is the limit of tickets/issues that a filter can contain to show in Excel 365 connector?