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 creation

Anthony Pitaval

Hi all,

I'd like to create a filter through a JQL search. The goal is to sort out all tickets created by two groups of users and created between Jan 1st and Dec 31st of a year (I'd like to run it for 2022, 2023, 2024 and coming years).

My request is the following:

assignee in membersOf("Hardware R&D France") or assignee in membersOf("Software R&D France") AND created > "2024/01/01"

I can get the tickets list but some from 2022 and 2023 were extracted too. How can I better define or restict the time slot and have the tickets of one year only?

Thanks for your help.

Anthony

Accepted answers

Kristine Daniels

Try adding parentheses around your assignee clauses

(assignee in membersOf("Hardware R&D France") or assignee in membersOf("Software R&D France")) AND created > "2024/01/01"

Evgenii

Hi, @Anthony Pitaval

You can use such filter, if you want to strictly declare year:

(assignee in membersOf("Hardware R&D France") or assignee in membersOf("Software R&D France")) AND (created >= "2024/01/01" AND created <= "2024/12/31")

Don't forget to use ( ) to group conditions. In my example i splitted conditions, that user must be in any of 2 groups, and filtered by date creation.
Without grouping your filter will select all issues for group "Hardware R&D France" AND all issues for "Software R&D France" created from the 01.01,2024

If you want to select issues for current year, you can use such JQL:

(assignee in membersOf("Hardware R&D France") or assignee in membersOf("Software R&D France")) AND (created >= startOfYear() AND created <= endOfYear())

All comments

Kristine Daniels

Try adding parentheses around your assignee clauses

(assignee in membersOf("Hardware R&D France") or assignee in membersOf("Software R&D France")) AND created > "2024/01/01"

Evgenii

Hi, @Anthony Pitaval

You can use such filter, if you want to strictly declare year:

(assignee in membersOf("Hardware R&D France") or assignee in membersOf("Software R&D France")) AND (created >= "2024/01/01" AND created <= "2024/12/31")

If you want to select issues for current year, you can use such JQL:

(assignee in membersOf("Hardware R&D France") or assignee in membersOf("Software R&D France")) AND (created >= startOfYear() AND created <= endOfYear())

Anthony Pitaval

Hi @Evgenii ,

Thanks for your help. Works fine.

Do you know whether it would be possible to only extract/display the month of the date.

The idea would be to have date formats like 2024-01 for months with one digit and 2024-10 for months with 2 digits.

That would help me a lot in the retreatment afterwards.

Thanks

Evgenii

Hi, @Anthony Pitaval

Not sure, that I understood the idea correctly. You want to take year and date from date field, like "Created" and save it in another custom field like "2024-09" ?

If answer is "yes", than you can use automation rule, which will make this operations on issue creation. Take date, parse it and save to anoher field of issue.

Anthony Pitaval

You understood well.

I've never used automation rules sp far. Is there some tutorials that I could use to help me do this operation?

Thanks for your help.

Welcome!

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

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud