search to filter out bugs status changed to ("Closed","Done") in order by (date_status changed only)

Question

for Atlassian JIRA (v5.2.11):

below is my query and what i want is just bugs that have had the status changed to ("Closed","Done") in desc order to appear in search results page. 
( developers are updating old closed/done bugs and they are appearing in search results page but all I want is search to filter out bugs status changed to ("Closed","Done") in order by (date_status changed) desc regardless of comment or anyother update )

my query:
project in (XXXXXX, YYYYYY) AND issuetype = Bug AND Status CHANGED FROM ("Blocked","Dev Complete","Feature Complete", "In Analysis","In Definition","In Development","In Front End Finalisation", "In Independent Test","In Progress","In Reqs Review","In Test","Not Started") to ("Closed","Done") order by updated desc

Filipp Chernikov · Answer

Thanks for the "DURING (-7d, now())" part.

mohammed Asif1 · Answer

thx, this is very usefull using DURING (-7d, now())

Udo Brand · Answer

I'm not quite sure what you want - your query works. The part of order by updated of course does not reflect the time when this status change occured since, as you said, there could be updates or comments.

If you want to identify issues where this status change was made in a certain time window (e.g. within the last 7 days) you could use following query with the DURING syntax.

project in (XXXXXX, YYYYYY) AND issuetype = Bug AND Status CHANGED FROM ("Blocked","Dev Complete","Feature Complete", "In Analysis","In Definition","In Development","In Front End Finalisation", "In Independent Test","In Progress","In Reqs Review","In Test","Not Started") to ("Closed","Done") DURING (-7d, now()) order by updated desc