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

Advanced Search Results

Sarah Elmer

Need advice on a filter. Need to have listed tickets that were worked on within the last week by a certain group. This is what I have:

(assignee was in membersOf(IT-Tech) or assignee was techsupport) AND updated >= -1w

The results I am getting are all tickets that have had action taken on them (no matter who took the action) that had been touched in the lifetime (we're talking sometimes a year) of that ticket.

How can I get just tickets that were touched in the last week by the particular group?

Accepted answers

Norman Abramovitz

The query looks correct assuming your group does not include everyone.

Here are some other ways to write the same thing (or close to it). I am doing these JQL from memory so there may be mistakes.

(assignee was in membersOf(IT-Tech) or assignee was techsupport) AND updated >= startOfWeek()

(assignee was techsupport and updated >= startOfWeek()) OR (
assignee was in membersOf(IT-Tech) and updated >= startOfWeek())

All comments

Jobin Kuruvilla [Adaptavist]

Your query looks right. Maybe do a full reindexing to see if indexes are out of place?

Sarah Elmer

Already tried that one. It's still pulling tickets that they had "touched" prior to the date range.

Norman Abramovitz

The query looks correct assuming your group does not include everyone.

Here are some other ways to write the same thing (or close to it). I am doing these JQL from memory so there may be mistakes.

(assignee was in membersOf(IT-Tech) or assignee was techsupport) AND updated >= startOfWeek()

(assignee was techsupport and updated >= startOfWeek()) OR (
assignee was in membersOf(IT-Tech) and updated >= startOfWeek())

Jobin Kuruvilla [Adaptavist]

What is the updated date on those tickets? prior to last 1 week?

Sarah Elmer

No, it's all tickets in the previous last 7 days.

Sarah Elmer

Thought about this set up, but then the date would have to be changed before running the filter to get the correct information. We're trying for it to automatically grab the last 7 days.

Norman Abramovitz

The -1w interval is the last seven days. Using startOfWeek() gives the current values for the current week as the week progresses. I guess it depends how you interpet "within the last week".

Sarah Elmer

Thanks for the clarification. Gave it a try. It's still picking up tickets that were updated within the last week, BUT the users designated have not touched in months. I need to only see the tickets that this group of users actually did action on for that time period (startofweek).

Norman Abramovitz

Does this JQL return what you are expecting?

(assignee was in membersOf(IT-Tech) after -1w or assignee was techsupport after -1w) AND updated >= -1w

You should be able to replace -1w with startOfWeek() as well.

Norman Abramovitz

The difference between the two queries should be the one without was will give you what is currently assigned to your group and user. The query on this answer is suppose to return issues assigned to your group or user even if they later assigned to a different user.

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-cloud

filter