Query for maintenance kanban

Hi Jon,

Thank you very much for your response, but unfortunately this did not work. Let me try to explain more fully what I'm trying to do, perhaps I'm going about it all the wrong way:

I'm trying to set up a kanban with the following swimlanes to aid in a maintenance queue for a large amount of websites. The plan is that there will be this board to allow developers to pull tickets whenever they have extra time, and to allow producers to gauge the level of the backlog to schedule maintenance sprints (planned on a separate scrum board) when the backlog becomes large enough.

Fast Track: This is for issues set with "High" priority, which are not labeled "backlog" or "hold." This is for issues that should be completed within the next couple of days.

Pull Next: This is for issues set with "Medium" or "Low" priority which are not labeled "backlog" or "hold." This is for issues which should be completed after everything in the Fast Track lane is completed.

Backlog: This is for ALL issues, regardless of priority, which are labeled "backlog." This is so that we can differentiate between what is "High" priority in the sense that it is an issue that does not need to be completed this week, but is highest in priority for the backlog.

Hold: This is for ALL issues, regardless of priority, which are labeled "hold." The label "hold" indicates that the issue is not yet ready for a developer to begin work, but I would still like to see the issue on the board to forecast what developer resources I'll need to allocate for in the near future.

The problem that I seem to be having is that my queries for issues based on priority are overriding the labels field.

Thanks!

4 answers

0 votes

Is this a new question or are you responding to someone else's answer on another question? You might want to continue on that one because people won't have a clue of what you are talking without the context associated with it.

Or if you want some help from us, post the queries you are using for your swimlanes because those are probably the cause of your problem.

Best regards,

Peter

Yes, I did mean to continue a prior conversation, but hit the wrong button.

Here are my queries:

Fast Track: priority = "High " ORDER BY createdDate

Pull Next: (priority = "Medium " OR priority = Low) ORDER BY createdDate

Backlog: (priority = "High " OR priority = "Medium " OR priority = Low) AND labels = backlog

HOLD: (priority = "High " OR priority = "Medium " OR priority = Low) AND labels = hold

Adam,

You'll need to use the following queries:

Fast Track: priority = "High " and labels != backlog and labels!= hold ORDER BY createdDate

Pull Next: (priority = "Medium " OR priority = Low) and labels != backlog and labels!= hold ORDER BY createdDate

The other ones are ok.

Best regards,

Peter

Hi Peter,

Thanks for the quick response. The swimlanes labeled "backlog" and "hold" seem to work, but all other issues are now under the "Everything Else" swimlane.

Hi Adam,

Try this :

Fast track: priority = High and labels not in ('backlog','hold')

Pull Next: (priority in ('Medium','Low') and labels not in ('backlog','hold')

Best regards,

Peter

Hi Peter,

I think the problem was with an empty labels field. I was able to achieve the desired result with these queries:

Fast Track: priority = "High " AND labels not in (backlog, hold) OR labels is EMPTY

Pull Next: priority in ("Medium ", Low) AND labels not in ('backlog', 'hold') OR labels is EMPTY

Thanks for your help!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 29, 2018 in Jira

How to set up an incident workflow from the VP of Engineering at Sentry

Hey Atlassian community, I help lead engineering at Sentry, an open-source error-tracking and monitoring tool that integrates with Jira. We started using Jira Software Cloud internally last year, a...

1,090 views 0 8
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you