JIRA : Advanced Search : JQL

0
votes

Issue:

Can not view issues that have been marked as 'closed' or 'done' within the last 30 days.

Tried:

assignee in (XX, YY) OR assignee in membersOf(AA) AND status in (Closed, Done) AND updatedDate = startOfDay(-30d)

Objective:

I need to select issues that are either closed or done be individuals and a group over the last 30 days. Would be so much better if there were a closedDate function here.

1
jirajql
What's the result so far? Can you tell us what's wrong with it? – timo.rieber

1 Answers

1
votes

Three suggestions which I think may solve your problem:

  1. Use parentheses around your assignee condition which uses OR operator to get only issues from assignees "XX", "YY" and members of "AA". Otherwise you would get ALL issues from assignees "XX" and "YY".

  2. Try to use resolutiondate instead of updatedDate, because the last one could have been changed after resolution.

  3. Use >= instead of = to get issues within the last 30 days. Otherwise you would only get issues resolved at this date, if any because of the timepart in this timestamp value.

The final query could look like this:

(assignee in (XX, YY) OR assignee in membersOf(AA)) AND status in (Closed, Done) AND resolutiondate >= startOfDay(-30d)