How to sort sys_updated_on sort by DATETIME

[kvijaykumar111]

Hi,

I am trying to retrieve data based on sys_updated_on   from incident table.

I want to sort that data based on sys_updated_on i tried below scenarios but didn't worked. Can some one please help me to sort sys_updated_on DATETIME.

1.sysparm_exclude_reference_link=false&sysparm_query=sys_updated_on>=2016-02-13 00:00:00&sysparm_limit=50&sysparm_display_value=true&sysparm_query=active=true^ORDERBYsys_updated_on&sysparm_order=importance&sysparm_order=sys_updated_on&sysparm_order_direction=asc

2.sysparm_exclude_reference_link=false&sysparm_query=sys_updated_on>=2016-02-13 00:00:00&sysparm_limit=50&sysparm_display_value=true&sysparm_query=active=true^ORDERBYsys_updated_on

3.sysparm_exclude_reference_link=false&sysparm_query=sys_updated_on>=2016-02-13 00:00:00&sysparm_limit=50&sysparm_display_value=true&sysparm_query=active=true^ORDERBYsys_updated_on

[shloke04]

Hi,

As per my understanding we can write a Before Query Business Rule on Updated Column on Incident Table which would help us in displaying the latest record being updated as per the code mentioned below:

Script:

function onBefore(current, previous) {

  //This function will be automatically called when this rule is processed.

  var query = 'ORDERBYDESCsys_updated_on';

  current.addEncodedQuery(query);

}

Hope this helps. Mark the answer as correct/helpful based on impact.

Regards,

Shloke

[kvijaykumar111]

Hi Shloke, Thanks for your reply.

I'm using Java to call service, if you don't mind, can you please elaborate how to add javascript to webservice.