FHIR Chat · Reporting · JIRA/Confluence

I need to analyze Jira content.
Desired: list of issues including WG, specification, status, date (& id or link to issue) that I can use to generate histograms on those dimensions and to drill into specific areas (to support Benefactor investment decisions.)

I should be able to use Search & Export to do this sort of thing in Excel, but export is capped.
This is for "Triaged":
Encountered a "403 - Forbidden" error while loading this page.
You are not allowed to get a result set of more than 1000 results. Current search returns 2896 results

Or I can filter down by workgroup or some other dimension and run the query many times. Is there another way?

Joshua Procious (Dec 13 2019 at 14:31):

Hello Jay, how are you currently accessing these pulls? Through the UI on jira.hl7.org?

Joshua Procious (Dec 13 2019 at 14:37):

If so, the easiest way to do what you described above (download in three sets and then concat) is to append &pager/start=1000 on second and &pager/start=2000 on third (and so forth) to the url that downloads your result set.

Joshua Procious (Dec 13 2019 at 14:37):

Alternatively, there are some REST solutions...

Joshua Procious (Dec 13 2019 at 14:38):

Since this is only 3 iterations that should work fairly well. If we run into something with 7k or more we'll want to use something else.

Jay Lyle (Dec 13 2019 at 14:50):

Thanks Josh. I'm using the "Export / CSV all fields" button on that page. A new window opens with the error message: it looks like the URL on that page is the query. I tried appending the &pager/start=1000 to the url on that page and it doesn't care. (It doesn't return the 1st 1000, either; it just complains.) I also tried start=0 and start=3000.

Jay Lyle (Dec 13 2019 at 14:51):

(that query returns 3048)

Joshua Procious (Dec 13 2019 at 14:51):

Do you require it's in csv? Is XML workable for you?

Jay Lyle (Dec 13 2019 at 14:52):

I could probably parse xml.

Joshua Procious (Dec 13 2019 at 14:55):

Give me just a few minutes Jay. I anticipate more people will need to do this in the future. I'm looking at add-ons that will allow CSV export as well.