Lower Case Issue

Question

Hi , I have a query which returns me a set of defects. One of the condition in my query is - label != Production . I need to track everyone who is not updating the label as 'P'roduction (Capital P) . now I am not able to track someone who updates the label with value - 'p'roduction ( lower case p). Can you please help ?

unknown · Answer

(type = defect AND status = closed AND label = "production" OR type = defect AND status = closed AND label != "Production")

This assumes you are looking for all defects that are closed with one label spelling and not the other.

Dheeraj_fl3cyq · Answer

Sorry that I have confused you.

I need to track all the defects that have been closed without adding the label as Production. production(lower case p) is also not allowed.

so the condition I tried goes like this - (label !=Production OR label = EMPTY).

But the above condition doesn't give me a track of all the defects which are closed with label = production.

unknown · Answer

Hi @Dheeraj,

To clarify, you want to omit issues with the labels "Production" and "production", is that correct?

If that is the case, you could use the JQL

label not in ("production", "Production")

Let me know if I have misunderstood your question.

Thanks