JQL搜索以排除字段中的多个值

发布于 2025-01-28 05:49:27 字数 302 浏览 6 评论 0 原文

我正在尝试提取一个错误报告,不包括所有已完成/封闭状态的错误。

到目前为止,我有此

“ dev team [dropdown]” =“ team name”和issueType = bug and status!=按优先desc 完成订单,

我审查了几篇以前的帖子

“ dev team [下拉]“ =“ Team Name”和IssueType = bug and status!=(完成,已关闭)按优先级desc 订购

,但是错误。

有建议吗?谢谢!

I am trying to pull a Bug report excluding all Bugs that are in a Done/Closed status.

So far I have this

"Dev Team[Dropdown]" = "Team name" AND issuetype = Bug AND status != Done ORDER BY priority DESC

I reviewed several previous posts that do

"Dev Team[Dropdown]" = "Team name" AND issuetype = Bug AND status != (Done, Closed) ORDER BY priority DESC

However, that errors out.

Any advice? Thanks!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(2

鲜血染红嫁衣 2025-02-04 05:49:27

“ dev team [下拉]” =“ team name”和issueType = bug and status!=(完成,已关闭)按优先级desc

此特定查询无效,因为!= 操作员将不支持字段状态的值。

尝试使用以下内容:

“ dev team [下拉]” =“ team name”和issueType = bug and status not(完成,已关闭)按优先级订单desc

参考:

https://support.atlass.atlass.atlassian.com/jira-software-com/jira-software-ware--software-ware--云/doc/Advanced-search-reference-jql-operators/

"Dev Team[Dropdown]" = "Team name" AND issuetype = Bug AND status != (Done, Closed) ORDER BY priority DESC

This particular query will not work because != operators will not support the values of the field status.

Try using this :

"Dev Team[Dropdown]" = "Team name" AND issuetype = Bug AND status not in (Done, Closed) ORDER BY priority DESC

Reference :

https://confluence.atlassian.com/jirakb/why-my-jql-search-with-not-in-or-not-equals-operators-has-issues-missing-1018766307.html

https://support.atlassian.com/jira-software-cloud/docs/advanced-search-reference-jql-operators/

绅刃 2025-02-04 05:49:27

尝试使用状态类别字段。因此,之类的东西

“ dev team [dropdown]” =“ team name”和issueType = bug and statuscategory!=按优先desc 完成订单,

如果您具有“正常”工作流程,例如完成的'完成'状态,被取消,拒绝,完成等,所有这些都具有“完成”的状态类别,因此您可以使用它来涵盖所有“完成”状态。

Try using the statusCategory field. So something like

"Dev Team[Dropdown]" = "Team name" AND issuetype = Bug AND statusCategory != Done ORDER BY priority DESC

If you have "normal" workflows your 'Done' statuses like Done, Cancelled, Rejected, Completed, etc., all have a statusCategory of 'Done' so you can use that to cover all the 'Done' statuses.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文