Skip to main content

Export update set to include its name - UI action

code a new processor:


 script

var sysid = g_request.getParameter('sysparm_sys_id'); var exporter = new ExportWithRelatedLists2('sys_remote_update_set', sysid); exporter.addRelatedList('sys_update_xml', 'remote_update_set'); exporter.exportRecords(g_response); var del = g_request.getParameter('sysparm_delete_when_done'); if (del == "true") { var ugr = new GlideRecord("sys_remote_update_set"); ugr.addQuery("sys_id", sysid); ugr.query(); if (ugr.next()) { ugr.deleteRecord(); } }









code a new UI action on the local update set table:



script:

var sURL = CUSTOMUTIL_ExportUpdate.exportUpdate(current.getUniqueValue()); action.setRedirectURL(sURL);



(alternatively use this script:

var updateSetExport = new UpdateSetExport();

var sysid = updateSetExport.exportUpdateSet(current);


action.setRedirectURL("export_update_set2.do?sysparm_sys_id=" + sysid + "&sysparm_delete_when_done=true");

)

code a script include.


var CUSTOMUTIL_ExportUpdate = Class.create(); CUSTOMUTIL_ExportUpdate.exportUpdate = function(sSysiD){ var grGlideRecord = new GlideRecord("sys_update_set"); if (grGlideRecord.get(sSysiD)){ var updateSetExport = new UpdateSetExport(); var sysid = updateSetExport.exportUpdateSet(grGlideRecord); return("export_update_set2.do?sysparm_sys_id=" + sysid + "&sysparm_delete_when_done=true"); } }; MTHDUTIL_ExportUpdate.prototype = { initialize: function() { }, type: 'MTHDUTIL_ExportUpdate' };

code a script include.



var ExportWithRelatedLists2 = Class.create(); ExportWithRelatedLists2.prototype = { initialize: function(parent_table, sys_id){ this.parent_table = parent_table; this.sys_id = sys_id; this.related_lists = []; this.query_sets = []; }, /** * Add related records * @param String child_table - table to query * @param String reference_field - field to query on */ addRelatedList: function(child_table, reference_field){ var related_list = [child_table, reference_field]; this.related_lists.push(related_list); }, /** * Add a query definition to define a collection of records to export, allows for custom queries that cannot be met with addRelatedList * @param String table * @param String query - encoded query string */ addQuerySet: function(table, query){ var set = [table, query]; this.query_sets.push(set); }, getFileName: function(){ var sResult = this.parent_table; var gr = new GlideRecord(this.parent_table); if (gr.get(this.sys_id)){ sResult = gr.getValue("name"); } return (sResult + '_' + this.sys_id + '.xml'); }, /** * Enable attachment support for all records being exported * @param boolean b */ setAttachments: function(b){ this.includeAttachments = b; }, /** * Required XML Headers */ setHeaders: function(response){ response.setHeader('Pragma', 'public'); response.addHeader('Cache-Control', 'max-age=0'); // setting the content type response.setContentType('application/octet-stream'); response.addHeader('Content-Disposition', "attachment;filename=\"" + this.getFileName() + "\""); }, /** * Process the request * @param {Object} response */ exportRecords: function(response){ this.setHeaders(response); var outputStream = response.getOutputStream(); this.hd = this.beginExport(outputStream); var gr = new GlideRecord(this.parent_table); gr.get(this.sys_id); this.exportRecord(gr); this.exportChildren(); this._exportQuerySets(); this.endExport(outputStream); }, /** * Export an individual GlideRecord * @param GlideRecord record */ exportRecord: function(record){ record = new GlideScriptRecordUtil.get(record).getRealRecord(); var recordSerializer = new GlideRecordXMLSerializer(); recordSerializer.setApplySecurity(true); recordSerializer.serialize(record, this.hd, new Packages.java.lang.String('INSERT_OR_UPDATE')); if (this.includeAttachments && record.getTableName().substring(0, 14) != "sys_attachment") { this.exportAttachments(record); } }, /** * Export attachments for a given GlideRecord * @param GlideRecord target */ exportAttachments: function(target){ var sa = new GlideSysAttachment(); //get sys_attachments var attach = new GlideRecord("sys_attachment"); attach.addQuery("table_name", target.getTableName()); attach.addQuery("table_sys_id", target.getUniqueValue()); attach.query(); while (attach.next()) { this.exportRecord(attach); var parts = sa.getAttachmentParts(attach.getUniqueValue()); while (parts.next()) { this.exportRecord(parts); } } }, /** * Get attachment document parts * @param GlideRecord attach - sys_attachment record */ _exportAttachDoc: function(attach){ var doc = new GlideRecord("sys_attachment_doc"); doc.addQuery("sys_attachment", attach.getUniqueValue()); doc.query(); }, /** * Process related lists */ exportChildren: function(){ for (var key = 0; key < this.related_lists.length; key++) { var table = this.related_lists[key]; this.exportTableChildren(table); } }, /** * Get the records from the related list entries * @param Array table - array of tableName, fieldName */ exportTableChildren: function(table){ var child = new GlideRecord(table[0]); child.addQuery(table[1], this.sys_id); child.query(); while (child.next()) { this.exportRecord(child); } }, /** * Process query sets and export results */ _exportQuerySets: function(){ for (var i = this.query_sets.length - 1; i >= 0; i--) { var querySet = this.query_sets[i]; var table = querySet[0]; var query = querySet[1]; var gr = new GlideRecord(table); gr.addEncodedQuery(query); gr.query(); while (gr._next()) this.exportRecord(gr); } }, /** * Initialize the result * @param {Object} outputStream */ beginExport: function(outputStream){ var streamResult = new Packages.javax.xml.transform.stream.StreamResult(outputStream); var tf = Packages.javax.xml.transform.sax.SAXTransformerFactory.newInstance(); var hd = tf.newTransformerHandler(); var serializer = hd.getTransformer(); serializer.setOutputProperty(Packages.javax.xml.transform.OutputKeys.ENCODING, 'UTF-8'); serializer.setOutputProperty(Packages.javax.xml.transform.OutputKeys.INDENT, 'yes'); hd.setResult(streamResult); hd.startDocument(); var attr = new GlidesoftGlideAttributesImpl(); attr.addAttribute("unload_date", GlideSysDateUtil.getUMTDateTimeString()); hd.startElement("", "", 'unload', attr); return hd; }, endExport: function(outputStream){ this.hd.endElement("", "", 'unload'); this.hd.endDocument(); outputStream.close(); }, }



















Comments

Popular posts from this blog

Get URL Parameter - server side script (portal or classic UI)

Classic UI : var sURL_editparam = gs . action . getGlideURI (). getMap (). get ( ' sysparm_aparameter ' ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); } Portal : var sURL_editparam = $sp . getParameter ( " sysparm_aparameter " ); if ( sURL_editparam == 'true' ) { gs . addInfoMessage ( 'parameter passed ); }

ServiceNow - script include: build up the results as a JSON object (array) - example 2

function call var sCurrentGroupMembers = new <script_include> (). getGroupMembers ( group_sysid ); gs . print ( 'sCurrentGroupMembers:' + sCurrentGroupMembers ); var oGroupMembers = JSON . parse ( sCurrentGroupMembers ); gs . print ( JSON . stringify ( oGroupMembers . users )); oNewGroupMember = JSON . parse ( group_members ); var oGroupConfig = getGroupDeltas ( oGroupMembers . users , oNewGroupMember ); gs . print ( JSON . stringify ( oGroupConfig . remove )); gs . print ( JSON . stringify ( oGroupConfig . add )) output : *** Script: sCurrentGroupMembers: {"manager":"3b2649efdb0f8c10cc0652f3f39xxxxx", "email":"", "type":"33a2226edb99c340edfc7cbdae96xxxx", "description":"Created for xyz", "users":[{"user":"3b2649efdb0f8c10cc0652f3f396xxxx"},{"user":"856a8f71db3d73041b4ffc45ae96196a"},{"user":"3752771