Advanced Search Results

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?

3 answers

1 accepted

1 vote
Accepted answer

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())

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.

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".

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).

I think we are all thinking of the query incorrectly. Let say, an issue is assigned to you. Five (5) weeks later the issue is still assigned to you and no changes was done. In the fifth week, is still assigned to you. Maybe query is asking who has the assignment this week.

I would try removing the word was and see if your results are any better.

You are a GENIUS! It worked! Thank you so much!

0 votes

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

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

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

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

Isn't that what you are querying? I am not sure what is the issue here!

I thought the issue was he was getting issues that were not worked on during the last 7 days by people he was not queryed for. If you try

assignee was techsupport after -1w

which should have worked, but I believe I am getting incorrect results on 5.1.7.

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.

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.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 27, 2018 in Portfolio for Jira

Introducing a new planning experience in Portfolio for Jira (Server/DC)

In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to   have–in   order to produce a reliable long-term roadmap. We're tur...

2,343 views 13 19
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