How to create a report that shows only the latest record created in a table in ServiceNow

Описание

In this video, we will create a report to show only the latest record. We will use the following logic in this:

1.Create a new Script Include with a function in it
2. In the function, run a GlideRecord on the target table with query and fetch only one record
3. Call the Script Include function in the Report

-----------------------------------------------------------------------------------------------------

Data Policies in ServiceNow
https://youtu.be/oWp5quUPLLw

What are Business Rules in ServiceNow
https://youtu.be/9nRA6KwpsHc

Integration in ServiceNow
https://youtu.be/W-kVzE3mA74

How to create Reports in ServiceNow
https://youtu.be/iay3oTXai7s

How to create personal Dashboards
https://youtu.be/nXl7pjsobz0

-----------------------------------------------------------------------------------------------------

Playlists:

Emails in ServiceNow Playlist
https://youtube.com/playlist?list=PLgMvigbxmqHQMg67-hgwjRviB2sQZwAjh

Integration Playlist
https://youtube.com/playlist?list=PLgMvigbxmqHQKRM0Xi06WhAEzSc_W_XcE

Reporting in ServiceNow
https://youtube.com/playlist?list=PLgMvigbxmqHQn7eQmXyw-bGmhopAJhrs8

ServiceNow Admin and Developer Training
https://youtube.com/playlist?list=PLgMvigbxmqHTCjv3LvLShtvh9bDAneSux


-----------------------------------------------------------------------------------------------------


Please subscribe to my channel.
https://www.youtube.com/c/HarditSingh


-----------------------------------------------------------------------------------------------------
Code:
var incidentUtil = Class.create();
incidentUtil.prototype = Object.extendsObject(AbstractAjaxProcessor, {
getLatestRecord: function() {

var incSysID;
var inc = new GlideRecord('incident');
inc.addActiveQuery();
inc.setLimit(1);
inc.orderByDesc('sys_created_on');
inc.query();
if (inc.next()) {
incSysID = inc.sys_id;
}
return incSysID;
},
type: 'incidentUtil'
});




-----------------------------------------------------------------------------------------------------



#servicenow #servicenowtokyo #tokyo #servicenowsandiego #san #diego #sandiego #servicenowrome #rome #flow #flowdesigner #inboundflow #schema #map #schemamap #tables #knowledge #articles #relatedlist #related #list #link #hyperlink #url #richtextlabel #kb #incident #task #parameters #url #record #new #servicenowquebec #quebec #survey #post #chat #chatbot #servicenowparis #servicenoworlando #servicenowdeveloper #paris #orlando #itil #itsm #newyork #agent #workspace #agentworkspace #virtualagent #virtual #agent #NLU #NLP #machinelearning #artificialintelligence #IOT #language #innovation #notifications #automated #sla #ola #uc #incident #task #location #display #GlideRecord #incident #incidentmanagement #drill #downs #drilldowns #drilldown #download #attachment #download #inactive #members
#report #access #dashboards #supervisor #manager #dashboard #onCellEdit #client #scripts #integration #RESTAPI #REST #API