985347 - Advanced search, custom search, does not allow you to to restrict field change criteria to retrieve just the *last* change

Status: RESOLVED DUPLICATE of bug 1543984

(Bugzilla :: Query/Bug List, enhancement)

Description

[Mike Budd]

User Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:27.0) Gecko/20100101 Firefox/27.0 (Beta/Release)
Build ID: 20140212131424

Steps to reproduce:

1. Navigated to Advanced Search ~ Custom search. 
2. Tried to set up search on *last* status change for a given record which met all the criteria (against the same field) of:
- changed to Unconfirmed
- changed before 7 days
- changed by <me>



Actual results:

2. Noted that search expression drop down only contained:
- 'changed to/from' 
- 'changed by'
- 'changed before/after'
Using these gave all records meeting the change criteria, not just those for which the *last* change met the criteria



Expected results:

2. There should probably also be expressions like:
- 'last changed to/from' 
- 'last changed by'
- 'last changed before/after'