Basics
To search issues with repeating go to Jira issue navigator and use JQL query:
codedoers.repeating.nextOccurrenceDate is not null
Sometimes it is possible that issue with repeating has empty nextOccurrenceDate. This occurs when:
- recurrence rule is not valid and nextOccurrenceDate can't be calculated
- repeating ends and issue should not be repeated anymore
Then you can use following JQL to search all issues with repeating (including invalid rules and completed recursion):
codedoers.repeating.rule is not null
All repeatings are defined as RFC 2445 recurrence rules, for example
- rRule = "INTERVAL=5;FREQ=MONTHLY;BYMONTHDAY=1"
- rRule = "INTERVAL=1;FREQ=DAILY"
The rRule property can be used to search repeatings by it recurrence details
...
| JQL | Result |
|---|---|
codedoers.repeating.nextOccurrenceDate is not empty | search all issues with repeating with valid next occurence occurrence date |
codedoers.repeating.rule is not empty | search all issues with repeating. Including invalid rules and completed recursion - with empty codedoers.repeating.nextOccurrenceDate |
codedoers.repeating.rule is not empty | as above, but the results are sorted ascending by the next occurrence date |
codedoers.repeating.nextOccurrenceDate > now() | search issues with repeating that occurs after now and until the end of week |
codedoers.repeating.rule ~ "FREQ=MONTHLY" | search all monthly repeatings |
codedoers.repeating.rule ~ "FREQ=DAILY" | search all daily repeatings |
codedoers.repeating.rule ~ "INTERVAL=5" | search all repeatings with intervel equals to 5 (interval is defined by Repeats every fields. see this page for details) |
codedoers.repeating.rule ~ "FREQ=MONTHLY" | search all montlhy repeatings with interval equals to 5 |
codedoers.repeating.repeatedBy is not empty | search all issues which are repeated by repeating issues add-on |
codedoers.repeating.repeatedBy = "ISSUEKEY-1" | search all issues which are repeated by ISSUEKEY-1 |
codedoers.repeating.repeatedBy = "ISSUEKEY-11" | search all issues which are repeated by ISSUEKEY-11 and was created after 2017-07-16 17:05 |
codedoers.repeating.hasErrors is not empty | search issues with repeating that failed during last execution |
JIRA 7.x.x JQL aliases and their equivalents in JIRA 6.x.x
| JQL alias (JIRA 7.x.x and above) | JIRA 6.x.x equivalent |
|---|---|
codedoers.repeating.rule | issue.property[com.codedoers.issue.recurrence].rRule |
codedoers.repeating.nextOccurrenceDate | issue.property[com.codedoers.issue.recurrence].nextOccurrenceDate |
codedoers.repeating.hasErrors | issue.property[com.codedoers.issue.recurrence.last].hasErrors |
codedoers.repeating.repeatedBy | issue.property[com.codedoers.issue.recurrence.source].issueKey |
...