如何使用JQL查询创建与解决日期同属一周的Epics及去年该类Epics

1. 获取创建日期与解决日期属于同一周的Epics列表 #

利用JQL的week()函数提取日期对应的周数，结合Epic类型和已解决状态的条件，即可筛选出目标Epics：

issueType = Epic AND resolved is not empty AND week(created) = week(resolved)

• issueType = Epic：限定问题类型为Epic
• resolved is not empty：确保Epic已被解决（存在有效解决日期）
• week(created) = week(resolved)：判断创建日期与解决日期处于同一周

2. 查询去年所有创建日期与解决日期属于同一周的Epics #

在基础查询条件上，添加去年时间范围的限制，通过startOfYear(-1)和endOfYear(-1)定位去年的起止节点：

issueType = Epic AND resolved is not empty AND created >= startOfYear(-1) AND created <= endOfYear(-1) AND week(created) = week(resolved)

• created >= startOfYear(-1) AND created <= endOfYear(-1)：限定Epic的创建时间落在去年区间内
• 其余条件与第一个查询一致，确保Epic已解决且创建、解决日期同周

内容的提问来源于stack exchange，提问作者Shrikant