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

5 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

Please sign in to leave a comment.