JQL using showing unexpected results

[Amzad Khan]

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 

[Stephen Wright _Elabor8_]

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