Sort by DueDate excluding 'not set' tickets

RT Users
1

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?

Thanks,
Tom

1 Like
2

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.

3

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.

I figured they were my only two options. Unfortunately I need tickets
that have no due date and I also can’t globally change the Search/
Results.html page as other queues have different uses of Due Date.

I’ll have to customise Search/Results.html for a few specific Queues.

Thanks,
Tom