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
To search issues with repeating that failed during last execution go to Jira issue navigator and use JQL query:
codedoers.repeating.hasErrors = "true"
More examples
| JQL | Result |
|---|---|
codedoers.repeating.nextOccurrenceDate is not empty | search all issues with repeating with valid next 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 |