OrderBy not working

[Community Alums]

Please see Gliderecord query I have below. I am pushing records to an array. The array is not getting sorted on 'number' field

var myTasks = [];

var task = new GlideRecord('u_hr_tasks');

var tsk = task.addQuery('assigned_to', user.sys_id);

              tsk.addOrCondition('assignment_group', 'IN', groupMember.join(','));

              task.addQuery('state', '<', '3');

        task.addQuery('parent', parent);

        task.orderBy('number');

              task.query();

      while (task.next()) {

        myTasks.push(task.number + '|' + task.assignment_group.name + '|' + short_description);

                  }

[ccajohnson]

It appears that you are doing a query on a custom table. Check to make sure the number field is not a custom field as well. It may be called u_number in which case, change your orderBy to use u_number instead.

[Daniel Draes]

Hmm, I would assume the u_hr_tasks table somehow inherits from task - quite some similar fields shown.

I modified the script therefor to run it on my instance:

var myTasks = [];

var task = new GlideRecord('task');

var tsk = task.addQuery('assigned_to', user.sys_id);

//               tsk.addOrCondition('assignment_group', 'IN', groupMember.join(','));

              task.addQuery('state', '<', '3');

      task.orderBy('number');

              task.query();

      while (task.next()) {

      myTasks.push(task.number + '|' + task.assignment_group.name );

                  }

gs.print(myTasks);

This worked just fine. I also tried orderByDesc, same. Works as it should.

Either your data table is somehow wrong, or your code is The orderBy works fine as long as the column exists and hold sortable data.