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

[Sharique Azim]

Hi Michiel,

As you are mentioning you can get the records of those records with no date value at the top using .orderBy('field');   , can you try using .orderByDesc('field name'.

Read GlideRecord - ServiceNow Wiki   for more info.

[Michiel Meijler]

Hi Sharique,

Thanks but ordering descending does not help. The records with null values will show at the end, but the other records are ordered incorrectly in that case.

What I need is a way to order first on valid dates in ascending order, then the records with null valued dates.

Regards,

Michiel

[Kalaiarasan Pus · Accepted solution]

You need to split these into 2 gliderecords. One with null and one without.

[Sharique Azim]

Exactly kalaiarasam,, i was about to type the same.