How to find empty projects?

Deleted user May 29, 2013

Hi There,

I was trying to make a jquery to list all the project(keys) wich have no issue but I can't seem to find one. I'm afraid JIRA doesn't support this functionality because I saw this question: https://answers.atlassian.com/questions/129235/find-inactive-projects-in-jira which has a redirect to this: https://jira.atlassian.com/browse/JRA-30664...

But maybe someone does have an answer?

Thank you in advance.

Daphne

4 answers

1 accepted

0 votes
Answer accepted
Mizan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 29, 2013

May be you can use this rest api https://docs.atlassian.com/jira/REST/latest/#id158276

You can use other rest methods and make a JQUERY which will return all the projects which have no issues in them

Mizan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 29, 2013

You can refer this tutorial for using REST in Jquery

http://www.j-tricks.com/1/post/2012/02/some-ajs-tricks.html

Deleted user May 29, 2013

Hi Mizan,

Thank you for your answer. It's a bit to technical for me. I will have to ask a developer to do this? Or could you give me directions?

Thanks,

Daphne

Mizan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 29, 2013

I thought you are developing the Jquery , You can share this with the developer .

You need to get all the projects using this REST call

Then pass each as a parameter to this rest call and check if it has issues

Like SSCI likes this
1 vote
kmkmkmkmkmkm May 6, 2014

SELECT COUNT(*) AS issuecount , project.pkey, pname 
FROM project, jiraissue 
WHERE project.id = jiraissue.project 
GROUP BY project.id HAVING COUNT(*) = 0;

0 votes
Deleted user June 6, 2013

Well I asked. They were already making a jquery to be able to determine which projects were inactive for 6 months and based on that the project would be put up for evaluation. So the answer from Mizan is the correct answer. Thank you for the help.

0 votes
Deleted user May 29, 2013

Hi Mizan,

I will ask a developer to help me. I will let you know.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events