用jql查询过期10天以上的issue
时间: 2023-02-22 16:30:34 浏览: 49
JIRA的JQL(JIRA Query Language)支持查询项目中符合特定条件的问题。如果要查询超过10天过期的问题,可以使用以下JQL查询:
```
project = <项目名称> AND resolution = Unresolved AND status = Open AND due < -10d
```
其中,"project = <项目名称>"表示你想查询的项目的名称;"resolution = Unresolved"表示只查询未解决的问题;"status = Open"表示只查询已打开的问题;"due < -10d"表示只查询过期10天以上的问题。
例如,如果要查询名为"ProjectA"的项目中超过10天过期的问题,可以使用以下JQL查询:
```
project = ProjectA AND resolution = Unresolved AND status = Open AND due < -10d
```
相关问题
jql function
JQL (Jira Query Language) functions are built-in or custom functions that can be used in Jira's advanced search and Jira Query Language (JQL) to search for issues that meet specific criteria.
There are many built-in JQL functions available in Jira, such as "assignee", "status", "project", "created", "updated", and "resolution". These functions allow you to search for issues based on various attributes, such as who they are assigned to, what their current status is, which project they belong to, when they were created or updated, and whether they have been resolved.
In addition to the built-in functions, you can also create custom JQL functions using Jira's ScriptRunner add-on. Custom functions can be created using Groovy, JavaScript, or other scripting languages, and can be used to search for issues based on complex criteria that cannot be achieved with the built-in functions alone.
Overall, JQL functions are a powerful tool for searching and filtering issues in Jira, and can help you quickly find the information you need.
Jira7.6查询一个需求单下有多少个缺陷的jql语句
可以使用以下 JQL 语句查询一个需求单下有多少个缺陷:
```
issueFunction in linkedIssuesOf("key = <需求单编号>", "is Epic of") AND issuetype = Bug
```
其中,`linkedIssuesOf` 表示查询指定的链接类型下的相关问题,`is Epic of` 表示查询需求单下的子任务和缺陷,`issuetype = Bug` 表示查询缺陷问题类型。将 `<需求单编号>` 替换为实际的需求单编号即可查询到该需求单下的所有缺陷。