Tickets :: [#7274] Search by dates

Summary	Search by dates
Queue	Whups
Queue Version	HEAD
Type	Enhancement
State	Resolved
Priority	1. Low
Owners	Jan Schneider <jan (at) horde (dot) org>
Requester	Duck <duck (at) obala (dot) net>
Created	09/01/08 (563 days ago)
Due
Updated	09/15/08 (549 days ago)
Assigned
Resolved	09/15/08 (549 days ago)
Attachments	whups[2].diff
Milestone
Patch	Yes

09/15/08	Jan Schneider	Assigned to Jan Schneider State ⇒ Resolved

09/15/08	CVS Commit	Comment #10	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/whups/lib/Query.php?r1=1.72&r2=1.73&ty=u

09/05/08	Duck	Comment #9	Reply to this comment
Duck, can you provide a fixed patch for this? I am sorry, I will be rather busy for the next month.

09/04/08	Jan Schneider	Comment #8	Reply to this comment
True. But then the date criteria have to be added under a new AND entry. This has to be done anyway, now that I think of it. Of course, parsing this out when editing a date criterion is much more complicated, but I've done that for other criteria too. Duck, can you provide a fixed patch for this?

09/03/08	Chuck Hagenbuch	Comment #7	Reply to this comment
Jan - that's not how the attribute criterion works though, right?

09/02/08	Jan Schneider	Comment #6	Reply to this comment
That was quick. Tweaked and committed, thanks. The query form doesn't work this way though. The form section must only edit a single criterion at a time, so it has to be changed to have drop down list with the possible date criteria and a single date picker.

09/02/08	CVS Commit	Comment #5	Reply to this comment
Changes have been made in CVS for this ticket: http://cvs.horde.org/diff.php/whups/docs/CHANGES?r1=1.207&r2=1.208&ty=u http://cvs.horde.org/diff.php/whups/lib/Driver/sql.php?r1=1.305&r2=1.306&ty=u http://cvs.horde.org/diff.php/whups/lib/Forms/Query.php?r1=1.8&r2=1.9&ty=u http://cvs.horde.org/diff.php/whups/lib/Forms/Search.php?r1=1.8&r2=1.9&ty=u http://cvs.horde.org/diff.php/whups/lib/Query.php?r1=1.71&r2=1.72&ty=u http://cvs.horde.org/diff.php/whups/lib/Renderer/Query.php?r1=1.5&r2=1.6&ty=u http://cvs.horde.org/diff.php/whups/query/index.php?r1=1.83&r2=1.84&ty=u http://cvs.horde.org/diff.php/whups/search.php?r1=1.119&r2=1.120&ty=u http://cvs.horde.org/diff.php/whups/search/rss.php?r1=1.1&r2=1.2&ty=u

09/02/08	Jan Schneider	Deleted Attachment: whups[1].diff

09/02/08	Jan Schneider	Deleted Attachment: whups.diff

09/02/08	Duck	Comment #4 New Attachment: whups[2].diff	Reply to this comment
Done. Now you can create/edit dates in query.

09/01/08	Duck	Comment #3 New Attachment: whups[1].diff	Reply to this comment
A new version allows query storage and rerun. Still needs fix of /lib/Forms/Query.php file. Help appreciated.

09/01/08	Jan Schneider	Comment #2 State ⇒ Feedback	Reply to this comment
Looks good, but has to be accompanied by an extension of the query manager, so that saving searches as queries still works.

09/01/08	Duck	Comment #1 Priority ⇒ 1. Low State ⇒ New New Attachment: whups.diff Patch ⇒ 1 Milestone ⇒ Queue ⇒ Whups Summary ⇒ Search by dates Type ⇒ Enhancement	Reply to this comment
Enlarge the search form and getTicketsByProperties() method to accept dates (updated, created, resoved, due and assigned) as filter criteria.