It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How to filter/search for issues that have not been updated in the last 5 days.

How do I write an advanced search for issues that have not been updated in the last 5 days?

I have updated before and after? should I use that?

5 answers

1 accepted

4 votes
Answer accepted

Use this in your query to find issues not updated within the last five days:

updated < -5d

This worked.

Do you know how to query for:

Issues that have been updated in the last 5-10 days.

Issues that have NOT been updated in the last 5-10days?

Thanks

General rule for the "not queries" is to save the query as filter, then write a new query and exclude this filter:

updated < -5d and updated > -10d 

 save this search as UpdatedBetween5and10d

filter != UpdatedBetween5and10d
Like 1 person likes this

This works but if i would like to search the issue that have not been updated in last 5 days by few users. I'll explain you scenario as under.

Onsite team is updating comment daily in JIRA but my team is not responding to that ticket since 15 days. If i use above query i'll not get that ticket in filter.

So i am looking for query which gives me result of tickets which were not updated by my team since X days.

I'm not sure I understand what you are asking for, but here's what I think you mean. Let me know if I misunderstood.

Issues that have been updated in the last 5-10 days:

If you mean issues that were last updated between 5 days ago and ten days ago, that would be this:

updated >-10d AND updated <-5d

Issues that have NOT been updated in the last 5-10days?

If you mean issues that were not updated between 5 days ago and ten days ago, that would be:

updated <-10d OR updated >-5d

Hi.

 

I want to know if exsit any filter to show the stories and task without estimation in time (effort), i want to have a filter to show what are the bad practices that my team has been doing.

@Carlos Medina RubioProbably best to create a new question rather than add this onto the end of an old, already-answered question about something different.

 

In your issue search, use something like this:

issuetype=story and timeestimate is empty

I don't know the name of the fields you use for your time estimates, so you may need to add your own field name there.

See https://confluence.atlassian.com/jirasoftwareserver079/advanced-searching-950291047.html (or the link for whatever version you are using) for more information on searching.

Ok, so many thanks... it was done

Hi, how can I check only Service Desk Issues - whitout an "external" update?

I will only check the comments for customer, not the internal ones...

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published Apr 09, 2019 in Portfolio for Jira

Portfolio for Jira 3.0 is here!

The wait is over... Portfolio for Jira Server and Data Center 3.0 is now officially here! Platform releases offer Atlassian an opportunity to shift our strategy, make bold predictions about t...

1,510 views 14 26
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