I want to retrieve most latest one importset number

Deepa12
Tera Contributor

HI,

could you please assist to retrieve most latest one import set number instead of query - sys_created_on today. i want to retrieve only one most latest one import set number if i run multiple times in a day.

var set;
var gr = new GlideRecord('sys_import_set');
gr.addEncodedQuery('table_name=u_gps_data_qa^data_source=a71970bc1b894050e19fb91bcd4bcb91^sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()');
gr.query();
gr.orderBy('sys_created_on');
while(gr.next());
{
set= gr.number;
}
gs.print(set);

 

2 REPLIES 2

Afsar2
Tera Contributor

Hi @Deepa ,

As you are interested in only 1 record (most recent).

You can use gr.setLimit(1); in the script after gr.orderBy('sys_created_on');

 

Please mark it helpful if this resolves your query.

 

Thank you,

Afsar Sheikh

Kurian Thomas P
ServiceNow Employee
ServiceNow Employee
var set;
var gr = new GlideRecord('sys_import_set');
gr.addEncodedQuery('table_name=u_gps_data_qa^data_source=a71970bc1b894050e19fb91bcd4bcb91^sys_created_onONToday@javascript:gs.beginningOfToday()@javascript:gs.endOfToday()');
gr.query();
gr.orderByDesc('sys_created_on');
gr.setLimit(1);

if(gr.next());
{
    set = gr.number+'';
}

gs.print(set);

 

order by descending and setLimit(1) will fetch the latest record

cheers,

please mark as helpful if it works šŸ˜„