[rt-users] Sort by DueDate excluding 'not set' tickets

[Jason Fenner]

Tom Lanyon wrote:
> Hi all,
>
> I need to sort tickets by due date ascending to display oldest due  
> dates first. Tickets with no due date should come after as there's no  
> impending timeline.
>
> However, because a due date of 'not set' is numerically 0, it sorts  
> before any tickets that have a due date set.
>
> Anyone have a solution/workaround for this?
>
>   
It looks like you have two options:

1) You can add to your search/query a line that says 'Due > 0'
What this will do is only return results that have a due date set, it will not return results without a due date set.
You could then run a separate query to see the tickets that do not have a due date set if you wanted to see those.

2) You could customize rt3/share/html/Search/Results.html to put tickets that have Due date 'not set' on the bottom of the results list.
This option would be a bit more involved, but you could make the search results page exactly how you wanted it to then.