Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Is there a problem with this jql

Ulrich Kone
Contributor
June 22, 2023

Hello I'm trying to see issues with a certain component with a custom field empty

I preform this filter "project = SUPP AND component in (MESSAGERIE) AND "Projet Jira" is EMPTY" but it doesn't show anything while there are many tickets in this case

 

Is there a way to have the good result? Or is my filter wrong?

 

Thank y'all for the concern

ATL COMMU.PNG

2 answers

0 votes
Deepak Jain
Community Champion
June 22, 2023

Hi @Ulrich Kone - Welcome to the Atlassian community !!

Request you to please check the JQL in different parts, like:

  • project = SUPP AND component in (MESSAGERIE)
  • project = SUPP AND "Projet Jira" is EMPTY"
  • project = SUPP
  • component in (MESSAGERIE)
  • "Projet Jira" is EMPTY"
  • component in (MESSAGERIE) AND "Projet Jira" is EMPTY"

It would help you to understand which criteria is leading to NO result.

And could you share a screenshot of an issue which is justifying this criteria ? And share some information on "Projet Jira" field.

Thank you !!

Ulrich Kone
Contributor
June 22, 2023

Hello @Deepak Jain 

Thanks for your answer. Il attached the screen needed.

The Custom Field is only set for the project SUPP and the component value too.

ATL COMMU - Component Mess and CustomFld Empty.PNGATL COMMU - Component Mess.PNGATL COMMU - SUPP and Component.PNGATL COMMU - SUPP and CustomFld empty.PNGATL COMMU - SUPP.PNG

Deepak Jain
Community Champion
June 22, 2023

Hi @Ulrich Kone 

Thanks for all these details, could you please let us know - "Project Jira" is what type of custom field ?

Thanks !

Ulrich Kone
Contributor
June 22, 2023

@Deepak Jain 

This custom field is a project single picker

Best regards

Deepak Jain
Community Champion
June 22, 2023

I doubt you are facing this Bug - https://jira.atlassian.com/browse/JRACLOUD-67435

Lot of users are facing this issue on Jira server also, could you please try workaround given in the ticket.

Thanks !!

Deepak Jain
Community Champion
June 22, 2023

You ca try workaround from here as well :

https://jira.atlassian.com/browse/JRACLOUD-76482

Thanks !!

0 votes
Valerie Knapp
Community Champion
June 22, 2023

Hi @Ulrich Kone , thanks for your question. Have you verified that there are issues that match this criteria? The green tick is indicating that the query is written correctly so I would check the issues first. 

Ulrich Kone
Contributor
June 22, 2023

Hello @Valerie Knapp, thanks for you answer. There are several issues that meet this criterion mentioned in the jql.

I don't understand the resultATL COMMU 2.PNG

Suggest an answer

Log in or Sign up to answer