Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

¿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.

1 answer

1 accepted

3 votes
Answer accepted

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.

JQL_Search.png

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.

Dashboard_Issue type.png

Hope this helps !!

 

Regards,

Vishwas

Muchas gracias! 

Like Vishwas N M likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

Next level incident management in Jira Service Management

Hello Atlassian Community! We’re thrilled to announce some exciting changes to incident management in Jira Service Management Cloud, in order to give your teams extra muscle during incidents, and ...

1,608 views 20 12
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you