¿Qué consulta JQL debo usar para listar los proyectos que no tienen ninguna issue de un tipo?

[ines_vilarino]

¿Qué consulta JQL debo usar para listar los proyectos que no tienen ninguna issue de un tipo en concreto?

Por ejemplo, listar todos los proyectos que no tienen ninguna tarea de tipo incidencia.

[Vishwas · Accepted solution]

Hey @ines_vilarino 

Welcome to Atlassian Community !!

Well JQL returns the set of issues at site level and when we restrict query by adding project = XYZ then it returns issues at XYZ project.

In your case you are looking to get the issues not in incident across all projects ?

so JQL would be like this issuetype != "[System] Incident"

This query returns all the issues across site which are not incidents.

In columns view you can add project parameter. After that export to csv and you can figure out the list of projects by this way.

Also you can create a Dashboard for the above JQL query too

In dashboard add "Two Dimensional Filter Statics" -> Select "Issue type" in y-axis and "Project" in x-axis. Like this the gadget showed me the list of projects without Incident Issues.

Hope this helps !!

Regards,

Vishwas

[ines_vilarino]

Muchas gracias!