ServiceNow News
662 items
A helpful utility to force updates into update sets including data records/scheduled jobs which may not normally be captured
<https://developer.servicenow.com/connect.do!/share/contents/9824957%5F...
go to _sys\_auto\_flush.list_ and locate the table in question, then set the value to the desired value
example:
[
Import
·
over 2 years
www.cloudminus89.com
cache
//--t-map on complete script
accountTableTrueUp(import\_set.number);
//accountTableTrueUp('ISET0011535');
function accountTableTrueUp (import\_set\_number) {
var grST \= new GlideRecord('x\_...
ServiceNow Transform Maps: check if all rows in the import staging table match the target rows
Import
·
over 2 years
www.cloudminus89.com
cache
link: <https://developer.servicenow.com/dev.do!/reference/api/utah/rest/c%5FImportSetAPI>
how you could loop through target records in an onComplete t-map script:
(Change the staging table name t...
ServiceNow Accessing the import_set api in a Transform Map Script
Import
·
over 2 years
www.cloudminus89.com
cache
example 'run script' code
(function transformRow(source, target, map, log, isUpdate) {
if (action\=='insert' && source.u\_status\=='I'){
gs.warn (source.u\_employeenumber + ' row ignored-dis...
ServiceNow Transform Map - prevent a particular row from being processed
Import
·
over 2 years
www.cloudminus89.com
cache
I've noticed by double clicking the breadcrumb the query comes up in a box, pretty cool
(note am currently on a Mac so left double clicking)
[
Import
·
over 2 years
www.cloudminus89.com
cache
where source date format:
_20140201000000Z_
var sStartDateImp\='20140201000000Z';
var sSD\_trunc\_y\=sStartDateImp.substring(0, 4);
var sSD\_trunc\_m\=sStartDateImp.charAt(4)+sStartDateImp.cha...
ServiceNow chars in string - date field from source HR system
Import
·
over 2 years
www.cloudminus89.com
cache
Haven't tested these all recently within global/local scopes, so feel free to have a play! option 1 use an encoded query embedded in the GlideRecord , e.g. var grProf = new GlideRecord ( 'x\_cls\_c...
ServiceNow adding Favorite in Next Experience UI - ServiceNow adding Favourite in Next Experience UI
Import
·
over 2 years
www.cloudminus89.com
cache
see also [my post](http://www.cloudminus89.com/2022/09/servicenow-how-to-access-audit-history.html) on how to retrieve by url using record sys\_id:
Use the set column and drop the sys\_id of the ...
ServiceNow how to export the audit history of a record
Import
·
over 2 years
www.cloudminus89.com
cache
If you are not extending GlideAjax, you need to initialize the class before defining the methods. Since you need it to be client-callable, you need to extend GlideAjax class.
Haven't tested these ...
ServiceNow ConversionError: The undefined value has no properties
Import
·
over 2 years
www.cloudminus89.com
cache