Ordering GlideRecord with null values

[Michiel Meijler]

Hi,

I need to order a list of tasks on a date field in Ascending order.

By using the orderBy('date_field') the the tasks without a value for the date_field, will be ordered on top. I want to have these tasks at the end of my resultset.

Anyone for a solution?

Michiel Meijler

ServiceNow Developing Consultant
Odysseus Group

[Anurag Tripathi]

I meant something like this

[utku]

Copy query will not include sorting if this was what you meant

.

[David Hubbard]

Ok - this is a little old - but I have the same requirement.  Although I needed to be able to page through the record, using "chooseWindow".

I ended up creating a "date_field_sort" field and using a Business Rule (Insert, Update) to either put the value of "date_field" or a high date value into the "sort" field.