Exporting a list of all projects from JIRA server. I want below details:
Project name + KeyProject ownerDate last updatesNumber of issues
Hi @RG ,
If you have Jira Administrative access. from front end you can try copy pasting these from Excel.
Settings icon --> projects -->
where you can see all your projects, Lead, total number of issues, last issue updated and etc.
You can copy these details and post in excel as Text. this will be easy.
Thanks,
Kagithala Babu Anvesh
@KAGITHALA BABU ANVESH We have around 800 projects and its time taking task.
Any other options?
@RG
Have you tried the project export feature of Better Excel Exporter?
You can get your projects into a real Excel file with a single click:
Yes, with Jira REST API, I just checked. The API is showing deprecated.
Can you please check the below.
https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-projects/
Please check the REST API's, These may be helpful
Hi @RG
I'm Leo from DEISER (Solution and Makertplace Partner)
Have you tried Projectrak?https://confluence.deiser.com/projectrak/8.1.1/export-to-excel-110953960.html
With Projectrak you can export to excel your projects, also, you can create some script fields like "Date last updates" or "Number of issues", this is an example for "Number of issues":
<span>package</span> deiser<span>.</span>profields<span>.</span>scripts <span>import</span> com<span>.</span>atlassian<span>.</span>jira<span>.</span>bc<span>.</span>issue<span>.</span>search<span>.</span>SearchService <span>import</span> com<span>.</span>atlassian<span>.</span>jira<span>.</span>component<span>.</span>ComponentAccessor <span>import</span> com<span>.</span>atlassian<span>.</span>jira<span>.</span>jql<span>.</span>builder<span>.</span>JqlQueryBuilder <span>import</span> com<span>.</span>atlassian<span>.</span>jira<span>.</span>web<span>.</span>bean<span>.</span>PagerFilter <span>// Components</span> <span>def</span> searchService <span>=</span> ComponentAccessor<span>.</span><span>getOSGiComponentInstanceOfType</span><span>(</span>SearchService<span>.</span><span>class</span><span>)</span> <span>def</span> jiraAuthenticationContext <span>=</span> ComponentAccessor<span>.</span>jiraAuthenticationContext <span>// Script variables</span> <span>def</span> loggedInUser <span>=</span> jiraAuthenticationContext<span>.</span><span>getLoggedInUser</span><span>(</span><span>)</span> <span>// Make JQL query</span> <span>def</span> query <span>=</span> JqlQueryBuilder<span>.</span><span>newBuilder</span><span>(</span><span>)</span> <span>.</span><span>where</span><span>(</span><span>)</span> <span>.</span><span>project</span><span>(</span>project<span>.</span>id<span>)</span><span>.</span><span>and</span><span>(</span><span>)</span> <span>.</span><span>buildQuery</span><span>(</span><span>)</span> <span>// Returns the issue count</span> <span>return</span> searchService<span>.</span><span>search</span><span>(</span>loggedInUser<span>,</span> query<span>,</span> PagerFilter<span>.</span>unlimitedFilter<span>)</span><span>.</span>results<span>.</span><span>size</span><span>(</span><span>)</span>
I hope it helps you!
Try Projectrak:https://marketplace.atlassian.com/apps/1210816/projectrak-project-tracking-for-jira?hosting=datacenter&tab=overview
Leo
It looks like you're new here. Sign in or register to get started.
