I want to retrieve most latest one importset number
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-28-2022 07:52 AM
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);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā01-29-2022 12:19 AM
Hi
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
ā02-09-2022 04:54 AM
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 š