Tickets :: [#8648] When searching for alarms, filter by the maximum alarm value

Summary	When searching for alarms, filter by the maximum alarm value
Queue	Kronolith
Queue Version	Git master
Type	Enhancement
State	Rejected
Priority	1. Low
Owners
Requester	chuck (at) horde (dot) org
Created	10/16/2009 (5718 days ago)
Due
Updated	07/01/2011 (5095 days ago)
Assigned
Resolved	07/01/2011 (5095 days ago)
Milestone
Patch	No

07/01/2011 08:33:31 PM	Jan Schneider	Comment #2 State ⇒ Rejected	Reply to this comment
This only helps when searching for alarms. And how many events do you really have so far in the future, but with an alarm set, that it's worth filtering them out?

10/16/2009 03:13:30 PM	Chuck Hagenbuch	Comment #1 State ⇒ Accepted Priority ⇒ 1. Low Type ⇒ Enhancement Summary ⇒ When searching for alarms, filter by the maximum alarm value Queue ⇒ Kronolith Milestone ⇒ Patch ⇒ No	Reply to this comment
Add an index on event_alarm, and then we can select max(event_alarm) and use that as a filter to ignore events that are far enough in the future that they can't have an alarm set.