JIRA filter for tasks aging that consider two dates i.e. due date and forecast due date

[Priyanka]

Hi,

I am trying to create a filter for Aging Open Tasks that were created 30 days ago in JIRA that considers two dates, i.e., "due date" (if the forecast due date is blank) and "forecast due date" (if the forecast due date is filled), for a two-dimension aging dashboard.

The filter created by me is not working as expected. Kindly support creating the correct filter for the aging dashboard.

Filter is as follows-

project = XYZ AND (issuetype = Task) AND (status in (Open)) AND (created >= startOfDay(-30d) AND (duedate <= now() AND "Forecast due date" is EMPTY)) OR ("Forecast due date" is not EMPTY AND "Forecast due date" <= now()) ORDER BY priority DESC, updated DESC

[Trudy Claspill]

Hello @Priyanka 

Welcome to the Atlassian community.

In what way is it not working? Are you getting a syntax error? Are the results not correct?

If the results are not correct, in what way are they not correct? Are you getting issues that you think should be excluded? Are you not getting issues that you think should be included?

I think one possible problem is that you should have another set of parentheses. I used indentation formatting below to show where they should be inserted - at line 3 and line 15.

project = XYZ AND (issuetype = Task) AND 
(status in (Open)) AND
( 
  (
    created >= startOfDay(-30d) AND 
    (
      duedate <= now() AND 
      "Forecast due date" is EMPTY
    )
  ) OR 
  (
    "Forecast due date" is not EMPTY AND 
    "Forecast due date" <= now()
  )
) 
ORDER BY priority DESC, updated DESC