JQL Filter Issue

[Josh Velez]

I currently have this JQL for a board

Team = 5314 AND issuetype not in subTaskIssueTypes() AND issuetype != Risk AND (Status != complete OR status changed to Complete after startOfDay(-25) ) ORDER BY Rank ASC

 I am trying to also inject a new issue type that is in working status or expected delivery within 30 days

[John Funk]

Hi Josh,

I would start by adding one element at a time see what works and when it doesn't return the results you want, and then tweak from there. 

[Josh Velez]

Thats what I have been doing and why I'm here now asking for help

[John Funk]

Very good - where is it breaking down for you? At what point/element does it not provide what you need? Do you get an error? Or it just doesn't return the right results? 

[Josh Velez]

The JQL in the code returns fine just when I try to add the second issue type the board times out.

[John Funk]

So exactly which part of the code is working with no problems? 

[Josh Velez]

The entire code posted is working fine

[Josh Velez]

Team = 5314 AND issuetype not in subTaskIssueTypes() AND issuetype != Risk AND (Status != complete OR status changed to Complete after startOfDay(-25)) OR issuetype = CDRL AND Status != "In Progress" AND ("Expected Delivery Date" >= startOfDay(30d)) ORDER BY issuetype DESC, Rank ASC

So this is what I have right now but the expected delivery date is not filtering out correctly. Its just show all CDRL issue types

[Bill Sheboy]

Hi @Josh Velez 

I believe you have an order of precedence thing happening with the OR clause.  Have you tried wrapping the two things you want in parentheses to clarify the OR condition?

Is this what you were trying to query?

Team = 5314
 AND
( 
(
 issuetype NOT IN subTaskIssueTypes()
 AND issuetype != Risk
 AND (
      Status != complete
      OR status CHANGED TO Complete AFTER startOfDay(-25)
     )
)
 OR
(
 issuetype = CDRL
 AND Status != "In Progress"
 AND "Expected Delivery Date" >= startOfDay(30d)
)
)
 ORDER BY issuetype DESC, Rank ASC

Best regards,

Bill

[Josh Velez]

So this didnt work. I have the two separate JQLs returning properly but when I combine them it doesnt work.

Team = 5314 AND (issuetype NOT IN subTaskIssueTypes() AND issuetype != Risk AND (Status != complete OR status CHANGED TO Complete AFTER startOfDay(-25)))

Team = 5314 AND (issuetype = CDRL AND Status != "In Progress" AND "Expected Delivery Date" <= startOfMonth(30d)) 

[Bill Sheboy]

One more thing to try: completely separate the queries and then OR the result sets.

(
 Team = 5314
 AND issuetype NOT IN subTaskIssueTypes()
 AND issuetype != Risk
 AND (
      Status != complete
      OR status CHANGED TO Complete AFTER startOfDay(-25)
      )
)
 OR
(
 Team = 5314
 AND issuetype = CDRL
 AND Status != "In Progress"
 AND "Expected Delivery Date" >= startOfDay(30d)
)
ORDER BY issuetype DESC, Rank ASC

[Josh Velez]

Still not working idk what the issue is when the two JQL are separate they work fine

[Bill Sheboy]

Thanks, Josh.  At this point I think you have two options:

1. If you only needed this one time, run the queries separately and merge the results in a spreadsheet after exporting
2. If you regularly need this query, talk to your site admin to submit a support request to Atlassian.  Perhaps the support team will see something the community is missing.  https://support.atlassian.com/contact/#/

Best regards,

Bill