英文:
JQL: Show all sub-tasks of stories in current sprint
问题
###背景###
我正在使用Atlassian的Confluence创建一个页面，用于显示我们团队的子任务。未完成状态的子任务将阻止Scrum主管关闭Sprint。
在我们的情况下，用户对故事和史诗的分配值（如sprintvalue、受让人或状态）并不像对待故事和史诗那样谨慎。
###目标###
为了确保我拥有阻止Sprint关闭的所有子任务的列表，我想在Confluence中生成一个列表
所有未完成的子任务-> 属于用户故事-> 当前活动的Sprint。
目前，我已经设置如下：
类型=子任务 且 状态!=已完成 且 父任务=
父任务字段仅支持按问题关键字或问题ID搜索，而不支持其他查询。这意味着我的原始想法不起作用：
类型=子任务 且 状态!=已完成 且 父任务=（类型=故事 且 sprint="Sprint 1"）
###注意###
我无法使用插件。
使用Atlassian Cloud
###答案###
正如Kevin所指出的，正如我已经担心的那样，只有通过使用插件如scriptrunner才能实现这一目标。到目前为止，选项似乎有：
- 尝试与管理员交谈，看看他们是否可以获得插件的许可。
- 费力地在JQL查询中输入所有用户故事的ID。这将需要几分钟来设置每个Sprint，但与为子任务点击每个故事一样需要工作。
- 尝试找到在Jira本身中可视化这一点的方法。由于对用户来说一切都被封锁，这可能不像看起来那么简单。
英文:
###Background###
I'm using Atlassian's Confluence to make a page where to display our teams subtasks. Subtasks that do not have the status Done will prevent the Sprint from being closed by the Scrummaster.
In our case, users do not assign values (like sprintvalue, assignee or status) with the same care as they do for stories and epics.
###Goal###
To make sure I have a list of all the subtask that would prevent a sprint from closing, I'd like to generate a list in confluence
All incomplete Sub-tasks -> that are part of a userstory -> which is the currently active sprint.
Currently, I have it set up like this:
type = sub-task AND status != Done AND parent =
The parent field only supports search by issue key or by issue ID, not by another query. This means that my original idea does not work:
type = sub-task AND status != Done AND parent = (type = story and sprint = "Sprint 1")
###Note###
I am in no position to use plugins.
Using Atlassian Cloud
###Answer###
As Kevin pointed out, and I already feared, this can only be done by using a plugin like scriptrunner. So far, the options seem:
- Try and talk to admins, see if they can get clearance on a plugin.
- Painstakingly input all the id's of the userstories in the JQL query. This will take a few minutes to set-up every sprint, but it is as much work as clicking every story for sub-tasks.
- Try to find a way to visualize this in Jira itself. Since everything is bolted shut for users, this might not be as straightforward as it seems.
答案1
得分: 1
抱歉，你需要一个插件来完成这个操作。我认为ScriptRunner可以做到这一点，但肯定还有其他插件可以实现。
你可以尝试一种奇特的解决方案，例如在父问题的转换或其他事件中注入数据到子任务中。这样，你可以在子任务本身中过滤数据。但是，我不建议这样做，因为它可能会变得非常混乱，很容易出现不同步的情况。此外，很可能还需要一个插件来实现这一点。
另一种可视化的方法是通过Jira中的面板。在那里，你可以直观地看到哪些子任务尚未完成，甚至可以使用快速筛选、泳道或卡片颜色来突出显示一些内容。
英文:
Unfortunately you will need a plugin to do that. I believe scriptrunner can do this, but there are surely others.
You might try an exotic workaround such as injecting data into your subtasks on transitions or other events of the parent issue. This way you can filter on the data in the subtask itself. However, I would not recommend this, as it can get very messy and it will be easy to get out of sync. Also, chances are large that you will also need a plugin for achieving that.
Another way of visualising this might be through a board in Jira. There you can visually see which subtasks are not done yet, and you might even play with quick filters, swimlanes or card colours to highlight some things.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论