Home → Suggestions →

Show tickets with no set milestone when sorting by priority

• Edit

Colin Bartolome

04 Mar, 2009 07:37 PM

I recently set my Tickets tab to default to this search:

responsible:me state:open sort:priority

This had the effect of hiding all my tickets with no set milestone. Logically, I would expect those to show up at the lowest possible priority (i.e., after every other ticket with a set milestone) instead of not at all. Maybe this could be a separate sort option?

1. 1 Posted by Colin Bartolome on 11 Mar, 2009 06:15 PM

   

   This also affects tickets assigned to undated milestones.

   • Edit

2. 2 Posted by Rick on 11 Mar, 2009 10:54 PM

   

   Ah, that has to do with the way mysql orders due dates. If you don't care about the database details, skip the rest of this paragraph :) The old way used a sort list like tickets.milestone_due_on, tickets.priority, tickets.updated_at desc. I just changed it to COALESCE(tickets.milestone_due_on, '2069-01-01'), tickets.priority, tickets.updated_at desc".freeze. I'm not totally happy with this solution, but it works for now.
   

   At any rate, tickets without a milestone or with an unscheduled milestone will appear at the bottom.

   I've also added a new sort option for ticket searches. You can now do sort:ticket-priority that completely disregards milestones. There's also sort:milestone-priority, which is the default sort:priority.

   • Edit

3. 3 Posted by Colin Bartolome on 11 Mar, 2009 10:57 PM

   

   Beautiful. Thanks!

   • Edit

4. brandi closed this discussion on 29 Jun, 2012 10:10 PM.