Jira中使用频率较高的JQL搜索语句
序号 | 搜索需求 | JQL语句 |
|---|---|---|
01 | 分配给我的待处理任务 | assignee = currentUser() AND resolution is EMPTY assignee = currentUser() AND resolution = Null assignee = currentUser() AND resolution = Unresolved |
02 | 我报告的并且没处理完成的任务 | reporter = currentUser() AND resolution is EMPTY |
03 | 某项目中已经过期的任务 | project = "XXX" AND due < now() |
04 | 某项目中7天后要过期的任务 | project = "XXX" AND due <= endOfDay(7d) |
05 | 某项目中72小时内没更新过的任务 | project = "XXX" AND updated <= -72h ORDER BY updated DESC |
06 | 某项目中没上传附件的Bug | project = "XXX" and type= Bug and attachments is EMPTY project = "XXX" and issuetype= Bug and attachments is EMPTY |
07 | 某项目中testers用户组的用户处理完成的任务 | project = "XXX" and assignee in membersOf("testers") and status = 已完成 |
08 | 某项目中最近30天解决的任务 | project = "XXX" and resolved >= startOfDay(-30d) |
09 | 某项目上即将发布的版本中还没解决的任务 | project = "XXX" and fixVersion = earliestUnreleasedVersion() and resolution is EMPTY |
10 | 某项目中重新打开的Bug | project = "XXX" and type = Bug and resolution changed from fixed to empty |
11 | 某项目中标题包含“服务器异常”的Bug | project = "XXX" and type = Bug and summary ~ “服务器异常” |
12 | 某项目上当前进行的Sprint中被标记的任务 | project = "XXX" and Sprint in openSprints() and Flagged = Impediment |
13 | 昨天至今我将状态从待办改为处理中的任务 | status changed FROM 待办 TO 处理中 BY currentUser() AFTER startOfDay(-1d) |
14 | 用户User1在2019年修改过的Issue | issue in updatedBy(User1, 2019-1-1, 2019-12-31) |
15 | 某项目中已发布版本中包含的任务 | project = "XXX" and fixVersion in releasedVersions() |
16 | 上周发生状态变化的Issue | status changed DURING (startOfWeek(-1), endOfWeek(-1)) |
17 | 以"is duplicated by"关系链接到某个Issue的任务 | issue in linkedIssues(PRO-1,"is duplicated by") |
18 | 最近3天关闭的Issue | status changed to closed AFTER startOfDay(-3d) ORDER BY resolutiondate |
|
|
|