JQL Help

[PhilSpo]

Okay so i have the following JQL:

(category = "Customer Projects" OR category = "Shared - Customer Project Workflow") AND labels = re-work

and it brings back the following results:

What i need to do now is add to the JQL so that it only brings back all those with a 'Re-work label' as Empty (None) as some of these are populated.

If i add AND "Re-work Label" is EMPTY onto the end of the JQL it brings back no results. I have tried different ways of adding that final part into the JQL with no luck.

Does anyone know the correct answer please?

Thanks

Phil

[Christian Czaia [Decadis AG] · Accepted solution]

Seems like that's the correct JQL. Is Re-work Label a custom label field? Is that a new field and maybe you haven't reindexed after adding the field to Jira?

What if you turn around the bit to state  "Re-work Label" is NOT EMPTY? Do you get the expected results?

Cheers

[PhilSpo]

Thank you Christian, Yes it was the lack of the Re-index that caused the problem.

School boy error on my part.

At least i know my JQL is fine :)

Thanks Again for your help.

Cheers

Phil

[Ignacio Pulgar]

Hi @PhilSpo ,

As a side note, while this part of your query contains absolutely correct syntax:

(category = "Customer Projects" OR category = "Shared - Customer Project Workflow")

I'd recommend this alternative but shorter way to retrieve the same issues:

category in ("Customer Projects", "Shared - Customer Project Workflow")

Best regards

[Ingo Mohr]

Hi Phil,

if you add

AND "Re-work Label" is EMPTY

, this probably returns an empty result because the entries all have a "Re-work Label" value - which is "None".

If you tell me what values "Re-work Label" can have and what type the field has (e.g. String, Enum, ...), I'll try to build you JQL query.

However, I am not sure I understand what you want to see exactly:

Do you want to see all issues (in one of the two categories AND label "re-work") that do have a "Re-work Label" value other than "None"?

Cheers

Ingo

[PhilSpo]

All sorted now Ingo, but thank you for the kind offer.

Cheers

Phil

[Sanjana _Alacriz_]

Hi @PhilSpo 

Not sure if I understood your problem correctly. If you are trying to fetch all issues where there is no Re-work label, then you should be using below JQL

(category = "Customer Projects" OR category = "Shared - Customer Project Workflow") AND labels != re-work

--Sanjana