Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

Problem

After configuring theĀ Requirements Management for Jira add-in for Microsoft Excel and loading data from any R4J Jira project, no issues are imported and only the header/columns are displayed in Excel.

Cause

The default maximum number of issues to returnĀ from Jira search results may have been configured to 0. In fetching issues to be imported, Excel add-in calls Jira APIGET /rest/api/2/search which is affected by the maximum allowable value configuration.

Solution

  1. As JIRA Administrator, go to System > General Configuration > Advanced Settings.

  2. Search for thejira.search.views.default.max key.

  3. Set value from 0 to the minimum count of issues (e.g. 1000).

    • See image for reference:

  4. Load data from a project in Excel add-in.

Filter by label (Content by label)
showLabelsfalse
max5
spacesREQ4J
showSpacefalse
sortmodified
typepage
reversetrue
labelsexcel vsto add-in
cqllabel = "excel" and type = "page"