Suggest using a variable for 'Time Series Field: None (use some of existing issues)' during a

So I'm trying to chart something like this:

Project = "Example" AND assignee was jim AND status was not in (DONE, CLOSED)

But use: Time Series Field: None (use some of existing issues) Which notes NB. The JQL query will be executed once per time period. The appropriate " DURING (X,Y)" will be automatically appended to the JQL query below

But the problem is that during only gets applied to the end of the query and JIRA only applies this to the last statement even if there's an AND. So I get the search: Project = "Example" AND assignee was jim AND status was not in (DONE, CLOSED) DURING ('2018/02/07', '2018/03/05')

Which gives me issues ever assigned to jim, that had those statuses during the time period.

But what I need for this to work in JIRA is: Project = "Example" AND assignee was jim DURING ('2018/02/07', '2018/03/05') AND status was not in (DONE, CLOSED) DURING ('2018/02/07', '2018/03/05')

So my suggestion is you change the way you add DURING to use a variable. So I could write something like: Project = "Example" AND assignee was jim $DURING AND status was not in (DONE, CLOSED) $DURING

And your tool would fill that in with the appropriate dates and updated tip text explained what variable to use.

Comments (2)