JQL using showing unexpected results

Amzad Khan_xg23n0

Hi,

I am using the below jql filter and used the custom fields, which are in Epic Issue Type, but still and getting issues with Issue Type = User Requirement.

("Country Review US COM[Dropdown]" in ("In Progress", Planned) AND "US_COM - Completion Due Date (F2C)[Date]" < endOfDay() OR
"Country Review US Com[Dropdown]" is EMPTY and "US_COM - Completion Due Date (F2C)[Date]"< endOfDay()) OR
(("Country Review US_CGT[Dropdown]" in ("In Progress", Planned) AND "US_CGT - Completion Due Date (F2C)[Date]" < endOfDay() OR
"Country Review US_CGT[Dropdown]" is EMPTY and "US_CGT - Completion Due Date (F2C)[Date]"< endOfDay()))
OR (("Country Review US_GTX[Dropdown]" in ("In Progress", Planned) AND "US_GTX - Completion Due Date (F2C)[Date]" < endOfDay() OR
"Country Review US_GTX[Dropdown]" is EMPTY and "US_GTX - Completion Due Date (F2C)[Date]"< endOfDay())) 

 

Highlighted items are the User Requirements issue type issues, which do not have the Custom fields used in the JQL, not sure still why they are appearing in the JQL 

Ste Wright

Hi @Amzad Khan 

Just because a field isn't on a screen, doesn't mean it isn't searched for in JQL. You could technically populate those fields from a bulk edit - it's just the fields aren't editable from a normal issue view.

This means you still need to specify this search is for Epics only in the JQL.

Ste