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; } } }

Creating a Search Filter - Combining two fields -

Elif Alverson

Hello,

I am trying to create a filter which will show the tickets of;

"Exception Expiration" field will be >= 365d OR Status is changed to " Approval Notification" >= 365d . How to combine for these requirements on the same filter?

Thanks for your help.

Elif

Accepted answers

Max Foerster - K15t

Hi Elif,

I'm don't understand what exactly you're trying to search for. So the "Exception Expiration" date should be at least 365 or more days in the future OR the status changed to another status "Approval Notification" in the future? Could you please explain the sense behind your search so we can maybe find a way to build a filter? Right now it will not be working that way. Additionally try and have a look at the very good documentation on JQL functions, fields and operators here: Advanced Searching

In general I guess "Exception Expiration" >= startOfDay(365) OR status changed to "Approval Notification" whatever you need here would be sufficient.

Best, Max

All comments

Max Foerster - K15t

Hi Elif,

In general I guess "Exception Expiration" >= startOfDay(365) OR status changed to "Approval Notification" whatever you need here would be sufficient.

Best, Max

Elif Alverson

@Max Foerster - K15t ,

I would like to see the tickets with the " Exception Expiration" date are 1 year or older AND the status changed to ""Approval Notification" 1 year ago or more ago in the same search/filter. Please let me know, if it is clear now.

Thank you,

Elif

Max Foerster - K15t

Hi Elif,

thanks for clarifying, it's much better now in what timely direction we're heading here. So something like this should work:

"Exception Expiration" <= startOfDay(-1y) AND status changed to "Approval Notification" BEFORE startOfDay(-1y)

Elif Alverson

@Max Foerster - K15t,

Thank you for your quick response.

I am sorry what I meant is if it possible to see the tickets fit both criteria ?

Tickets with "Exception Expiration" <= startOfDay(-1y)

status changed to "Approval Notification" BEFORE startOfDay(-1y).

I tried this one;

STATUS != CLOSED AND status changed to "Approval Notification" BEFORE startOfDay(-1y) or "Exception Expiration" <= startOfDay(-1y)

It shows me 48 tickets

When I try this one;

STATUS != CLOSED AND "Exception Expiration" <= startOfDay(-1y) or status changed to "Approval Notification" BEFORE startOfDay(-1y)

I see 53 tickets with 5 of them are closed ones.

I want to be sure that the filter I am using shows me all the tickets which are not closed with the "Exception Expiration" <= startOfDay(-1y) or status changed to "Approval Notification" BEFORE startOfDay(-1y).

Which one should I use?

Welcome!

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

Quick Links

Find more posts tagged with

jira

jira-development

jira-administration

filter