2 Replies Latest reply on Oct 22, 2010 10:06 AM by Stu McNeill

    Sort order of a query using breach time where some incidents do not have a breach time

    Leanne Apprentice

      Using 7.3.2 - I have created a query which displays the current group workload, with the incidents which are going to breach soonest at the top of the results view.  However, because we also have some incidents which do not have an expiry date or time set, they are showing at the very top of the workload list - but I want them to appear at the end of the workload list - maybe in creation date order, but still have the incidents in ascending breach order at the top of the results view.

       

      Has anyone got any ideas or already achieved this?  I don't want the results to be grouped, just displayed in one continuous list.