nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Filter tickets by priority and labels

Sergio Herrero Querol

Hello,

I want to get tickets with 30 days age, not updated in the last 7 days wit a priority = a Critical (without labels) and Major with a specific label.

Whit this filter only get the Critical. Can you help me?

project = FPFISSUPP AND status in (Open, "In Progress", Reopened) AND assignee is not EMPTY AND created > "-30d" AND updated <=endOfDay(-7d) AND priority >= Critical ORDER BY created ASC

Accepted answers

All comments

Pete Singleton

Presumably "Critical" is your highest priority? So your query of "Priority >= Critical" will not return those issues with Major priority.

Try (Priority = Major OR Priority = Critical)

Jack Brickey

Slight variation here. It seems like you want for Critical issues or Major issues that have a certain label so...

...And (Priority = critical role (priority = major and labels = xxxxx))

Sergio Herrero Querol

Hello @Jack Brickey and @Pete Singleton . Jack is following my point. I need to filter both but I did something wrong because with this new filter do not get tickets at all

This is my updated filter:

project = FPFISSUPP AND status in (Open, "In Progress", Reopened) AND assignee is not EMPTY AND created > "-30d" AND updated <=endOfDay(-7d) AND (priority = Critical OR (priority = Major and labels = xxxxxxx)) ORDER BY created DESC

If I sue a similar filter without managing priority a get tickets (major and critical) with the label

project = FPFISSUPP AND status in (Open, "In Progress", Reopened) AND assignee is not EMPTY AND labels = xxxxxxx ORDER BY created DESC

What I am doing wrong?

Jack Brickey

Your first filter looks ok I think. Your second filter isn’t a ‘fair’ test though. A better test of removing priority would be

project = FPFISSUPP AND status in (Open, "In Progress", Reopened) AND assignee is not EMPTY AND created > "-30d" AND updated <=endOfDay(-7d)

and then see if you have any Critical.

now, one question here - is the label only for Major or does it apply to Critical too? If so then use ...AND (priority in (critical, major) and labels = xxxxx)

Sergio Herrero Querol

Dear @Pete Singleton and @Jack Brickey ,

I am sorry to be a pain but I do not achieve my goal.

Matters related to priority is fine now but is not fine regarding dates. What I need is (first of all) to get last 30 days tickets and in this range the ones not commented in the last week, You need to know my aim, I want to follow these important tickets (for me) which are a bit abandoned.

It is supposed that with this filter only appear tickets with comments older than one week but I get tickets opened 20 days ago but with a comment made today

project = FPFISSUPP AND status in (Open, "In Progress", Reopened) AND assignee is not EMPTY AND created > "-30d" AND Updated > "-7d" AND (priority = Critical OR (priority = Major and labels =xxxxxxx )) ORDER BY created ASC

Pete Singleton

You have changed updated "<=" to ">"... so you are showing things that have been updated after 7 days ago. To show those not updated you need to do "Updated <= -7d"

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server

filter

atl-gruland