Report to show projects with no issues open

Avatar
Declan
Created

I would like to find a way to report on which reports do not have any active issues assigned to them.

This could also include Issues that are resolved.

 

Votes

0

Share

7 comments
Avatar
Sergey Kochetkov
Created
Official comment

Hello Declan,

 

Thank you for your reply. Unfortunately, there is no such functionality or report available, however, I can suggest acquiring that information via REST API. I've made a simple JS script that returns an array of projects with 0 issues assigned to them to the browser's console. But before we start, you should create a permanent token for the user which has access to all the projects: https://www.jetbrains.com/help/youtrack/standalone/Manage-Permanent-Token.html#obtain-permanent-token

After that please fill in URL and token variables in the script below, open %URL%.myjetbrains.com website (otherwise you'll have to change the CORS settings) and paste the said script into the browser developer tools:

const projects = [];
const URL = 'https://%URL%.myjetbrains.com/youtrack/api/admin/projects?fields=name,id,issues($top=1)';
const token = '%token%';

(async () => {
    let responce = await fetch(URL, {
        headers: {
            "Authorization": `Bearer ${token}`,
            "Content-type": "application/json",
            "Accept": "application/json",
            "Accept-Charset": "utf-8",
        }
    });
    let responseData = await responce.json();

    for (const project of responseData) {
        
        if (project.issues.length === 0) {
            
            projects.push(project.name);
        }
    }
    
    return console.log(projects);

})();

Please let me know if it helps.

Avatar
Liubov Dievskaia
Created

Hello Declan,

could you please elaborate on your use case a bit? Do you want to see a list of projects, a list of users, or a list of issues? 

0
Avatar
Declan
Created

Hi Liubov, 


I want to see a list of Projects.

Thanks,
Declan

0
Avatar
Sergey Kochetkov
Created

Hello Declan,

 

Thank you for your reply. Please check the Issue per project report out: https://www.jetbrains.com/help/youtrack/standalone/Issues-per-Project.html

Should you have further questions please don't hesitate to ask.

0
Avatar
Declan
Created

Hi,

Thank you for your response, however, the page does not show me how to create the report I need.

I need to see what projects have 0 issues. Is there a way to report on this?

 

Thanks,

Declan

0
Avatar
Julian Rdnz
Created

Hi, for completeness:

Sergey's script works, but not if you have a lot of projects in your Youtrack instance. See adapted version; you might change 300 to a higher number.

With this script, you get a list of projects in your Youtrack which contain no issues.

const projects = [];
const URL = 'https://<Your-Youtrack>.com/api/admin/projects?fields=name,id,issues($top=1)&$top=300';
const token = '<Permanent Token>';

 

(async () => {
   let responce = await fetch(URL, {
       headers: {
           "Authorization": `Bearer ${token}`,
           "Content-type": "application/json",
           "Accept": "application/json",
           "Accept-Charset": "utf-8",
       }
   });
   let responseData = await responce.json();

   for (const project of responseData) {
       
       if (project.issues.length === 0) {
           
           projects.push(project.name);
       }
   }
   
   return console.log(projects);

})();

By the way, I'm not sure whether this fits OPs needs, as this list would not contain projects which don't have active issues; this is only about the number of issues.

Best, Julian

0
Avatar
Sergey Merzlov
Created

Thanks for sharing the script, Julian. 

By the way, I'm not sure whether this fits OPs needs, as this list would not contain projects which don't have active issues; this is only about the number of issues.

Given that the thread is more than 4 years old, it's hard to tell if the case is still relevant for the OP. Still though, I hope it will be helpful for those who stumble upon this thread with a similar need. 

0

Please sign in to leave a comment.