| Both sides previous revisionPrevious revision | |
| update_sets [01/08/2025 13:08] – johnsonjohn | update_sets [12/31/2025 05:43] (current) – removed johnsonjohn |
|---|
| ======Update Sets====== | |
| ---- | |
| =====Main Update Sets===== | |
| ---- | |
| ====UserLog Complete Update Set===== | |
| <code> | |
| <?xml version="1.0" encoding="UTF-8"?><unload unload_date="2025-01-08 18:09:28"> | |
| <sys_remote_update_set action="INSERT_OR_UPDATE"> | |
| <application display_value="Global">global</application> | |
| <application_name>Global</application_name> | |
| <application_scope>global</application_scope> | |
| <application_version/> | |
| <collisions/> | |
| <commit_date/> | |
| <deleted/> | |
| <description/> | |
| <inserted/> | |
| <name>JWJ-User Log Complete-2025 MAIN</name> | |
| <origin_sys_id/> | |
| <parent display_value=""/> | |
| <release_date/> | |
| <remote_base_update_set display_value=""/> | |
| <remote_parent_id/> | |
| <remote_sys_id>9bfb88ec97c35a9035e97666f053afc5</remote_sys_id> | |
| <state>loaded</state> | |
| <summary/> | |
| <sys_class_name>sys_remote_update_set</sys_class_name> | |
| <sys_created_by>jwj0215</sys_created_by> | |
| <sys_created_on>2025-01-08 18:09:28</sys_created_on> | |
| <sys_id>6cfe846497075a9035e97666f053afa7</sys_id> | |
| <sys_mod_count>0</sys_mod_count> | |
| <sys_updated_by>jwj0215</sys_updated_by> | |
| <sys_updated_on>2025-01-08 18:09:28</sys_updated_on> | |
| <update_set display_value=""/> | |
| <update_source display_value=""/> | |
| <updated/> | |
| </sys_remote_update_set> | |
| <sys_update_xml action="INSERT_OR_UPDATE"> | |
| <action>INSERT_OR_UPDATE</action> | |
| <application display_value="Global">global</application> | |
| <category>customer</category> | |
| <comments/> | |
| <name>sys_documentation_u_log_u_string1_en</name> | |
| <payload><![CDATA[<?xml version="1.0" encoding="UTF-8"?><record_update><sys_documentation element="u_string1" label="V1" language="en" table="u_log"><sys_documentation action="INSERT_OR_UPDATE"><element>u_string1</element><help/><hint/><label>V1</label><language>en</language><name>u_log</name><plural>V1s</plural><sys_class_name>sys_documentation</sys_class_name><sys_created_by>ggb0926</sys_created_by><sys_created_on>2023-08-31 20:13:43</sys_created_on><sys_id>38d65e749705f1103e1432890353af19</sys_id><sys_mod_count>0</sys_mod_count><sys_name>V1</sys_name><sys_package display_value="Global" source="global">global</sys_package><sys_policy/><sys_scope display_value="Global">global</sys_scope><sys_update_name>sys_documentation_u_log_u_string1_en</sys_update_name><sys_updated_by>ggb0926</sys_updated_by><sys_updated_on>2023-08-31 20:13:43</sys_updated_on><url/><url_target/></sys_documentation></sys_documentation></record_update>]]></payload> | |
| <payload_hash>1084615597</payload_hash> | |
| <remote_update_set display_value="JWJ-User Log Complete-2025 MAIN">6cfe846497075a9035e97666f053afa7</remote_update_set> | |
| <replace_on_upgrade>false</replace_on_upgrade> | |
| <sys_created_by>jwj0215</sys_created_by> | |
| <sys_created_on>2025-01-08 18:09:28</sys_created_on> | |
| <sys_id>20fe8ca497075a9035e97666f053afa0</sys_id> | |
| <sys_mod_count>0</sys_mod_count> | |
| <sys_recorded_at>194471a4b2f0000001</sys_recorded_at> | |
| <sys_updated_by>jwj0215</sys_updated_by> | |
| <sys_updated_on>2025-01-08 18:09:28</sys_updated_on> | |
| <table>u_log</table> | |
| <target_name>User Log.V1</target_name> | |
| <type>Field Label</type> | |
| <update_domain>global</update_domain> | |
| <update_guid>9eae84a4a2075a90c27e8ed5fae76132</update_guid> | |
| <update_guid_history>9eae84a4a2075a90c27e8ed5fae76132:1084615597,fcd65e747205f11041400660f1bea157:1084615597</update_guid_history> | |
| <update_set display_value=""/> | |
| <view/> | |
| </sys_update_xml> | |
| <sys_update_xml action="INSERT_OR_UPDATE"> | |
| <action>INSERT_OR_UPDATE</action> | |
| <application display_value="Global">global</application> | |
| <category>customer</category> | |
| <comments/> | |
| <name>sys_security_acl_bcd61e749705f1103e1432890353afc6</name> | |
| <payload><![CDATA[<?xml version="1.0" encoding="UTF-8"?><record_update table="sys_security_acl"><sys_security_acl action="INSERT_OR_UPDATE"><active>true</active><admin_overrides>true</admin_overrides><advanced>false</advanced><condition/><description>Default access control on u_log</description><local_or_existing>Local</local_or_existing><name>u_log</name><operation display_value="delete">delete</operation><script/><security_attribute/><sys_class_name>sys_security_acl</sys_class_name><sys_created_by>ggb0926</sys_created_by><sys_created_on>2023-08-31 20:13:43</sys_created_on><sys_id>bcd61e749705f1103e1432890353afc6</sys_id><sys_mod_count>0</sys_mod_count><sys_name>u_log</sys_name><sys_package display_value="Global" source="global">global</sys_package><sys_policy/><sys_scope display_value="Global">global</sys_scope><sys_update_name>sys_security_acl_bcd61e749705f1103e1432890353afc6</sys_update_name><sys_updated_by>ggb0926</sys_updated_by><sys_updated_on>2023-08-31 20:13:43</sys_updated_on><type display_value="record">record</type></sys_security_acl></record_update>]]></payload> | |
| <payload_hash>-983451686</payload_hash> | |
| <remote_update_set display_value="JWJ-User Log Complete-2025 MAIN">6cfe846497075a9035e97666f053afa7</remote_update_set> | |
| <replace_on_upgrade>false</replace_on_upgrade> | |
| <sys_created_by>jwj0215</sys_created_by> | |
| <sys_created_on>2025-01-08 18:09:28</sys_created_on> | |
| <sys_id>20fe8ca497075a9035e97666f053afa3</sys_id> | |
| <sys_mod_count>0</sys_mod_count> | |
| <sys_recorded_at>194471a4e840000001</sys_recorded_at> | |
| <sys_updated_by>jwj0215</sys_updated_by> | |
| <sys_updated_on>2025-01-08 18:09:28</sys_updated_on> | |
| <table>u_log</table> | |
| <target_name>u_log</target_name> | |
| <type>Access Control</type> | |
| <update_domain>global</update_domain> | |
| <update_guid>eaae84a4fc075a9076906267220e317e</update_guid> | |
| <update_guid_history>eaae84a4fc075a9076906267220e317e:-983451686,f03d6aaeeaf10a9461f6793eb1bcf3b8:-983451686,70d61e74c405f1109a476c5a0c655dc9:400037648</update_guid_history> | |
| <update_set display_value=""/> | |
| <view/> | |
| </sys_update_xml> | |
| <sys_update_xml action="INSERT_OR_UPDATE"> | |
| <action>INSERT_OR_UPDATE</action> | |
| <application display_value="Global">global</application> | |
| <category>customer</category> | |
| <comments/> | |
| <name>sys_documentation_u_log_sys_mod_count_en</name> | |
| <payload><![CDATA[<?xml version="1.0" encoding="UTF-8"?><record_update><sys_documentation element="sys_mod_count" label="Updates" language="en" table="u_log"><sys_documentation action="INSERT_OR_UPDATE"><element>sys_mod_count</element><help/><hint/><label>Updates</label><language>en</language><name>u_log</name><plural>Updates</plural><sys_class_name>sys_documentation</sys_class_name><sys_created_by>jwj0215</sys_created_by><sys_created_on>2023-09-01 16:35:37</sys_created_on><sys_id>737ea2cd974d35903d05df14a253af88</sys_id><sys_mod_count>0</sys_mod_count><sys_name/><sys_package/><sys_policy/><sys_scope/><sys_update_name/><sys_updated_by>jwj0215</sys_updated_by><sys_updated_on>2023-09-01 16:35:37</sys_updated_on><url/><url_target/></sys_documentation></sys_documentation></record_update>]]></payload> | |
| <payload_hash>11693833</payload_hash> | |
| <remote_update_set display_value="JWJ-User Log Complete-2025 MAIN">6cfe846497075a9035e97666f053afa7</remote_update_set> | |
| <replace_on_upgrade>false</replace_on_upgrade> | |
| <sys_created_by>jwj0215</sys_created_by> | |
| <sys_created_on>2025-01-08 18:09:28</sys_created_on> | |
| <sys_id>24fe8ca497075a9035e97666f053af9f</sys_id> | |
| <sys_mod_count>0</sys_mod_count> | |
| <sys_recorded_at>194471a4b890000001</sys_recorded_at> | |
| <sys_updated_by>jwj0215</sys_updated_by> | |
| <sys_updated_on>2025-01-08 18:09:28</sys_updated_on> | |
| <table>u_log</table> | |
| <target_name>User Log.Updates</target_name> | |
| <type>Field Label</type> | |
| <update_domain>global</update_domain> | |
| <update_guid>5aae84a431075a90698134d008cdf845</update_guid> | |
| <update_guid_history>5aae84a431075a90698134d008cdf845:11693833,f0917e54df123550ed9fa4268520b12d:11693833</update_guid_history> | |
| <update_set display_value=""/> | |
| <view/> | |
| </sys_update_xml> | |
| <sys_update_xml action="INSERT_OR_UPDATE"> | |
| <action>INSERT_OR_UPDATE</action> | |
| <application display_value="Global">global</application> | |
| <category>customer</category> | |
| <comments/> | |
| <name>sys_script_include_5c0bb7021b307d10c4fec913604bcba7</name> | |
| <payload><?xml version="1.0" encoding="UTF-8"?><record_update table="sys_script_include"><sys_script_include action="INSERT_OR_UPDATE"><access>public</access><active>true</active><api_name>global.UserLog</api_name><caller_access/><client_callable>false</client_callable><description>Writes to custom User Log (table u_log). Includes a timestamp.</description><name>UserLog</name><script><![CDATA[function UserLog(v0, v1, v2, v3, v4, v5, v6, v7, v8, v9) | |
| { | |
| var gdt = new GlideDateTime(); | |
| |
| var grNew = new GlideRecord("u_log"); | |
| grNew.initialize(); | |
| grNew.u_string0 = v0; | |
| grNew.u_string1 = v1; | |
| grNew.u_string2 = v2; | |
| grNew.u_string3 = v3; | |
| grNew.u_string4 = v4; | |
| grNew.u_string5 = v5; | |
| grNew.u_string6 = v6; | |
| grNew.u_string7 = v7; | |
| grNew.u_string8 = v8; | |
| grNew.u_string9 = v9; | |
| grNew.u_timestamp = gdt.getLocalDate() + " " + gdt.getUserFormattedLocalTime() + " " + AddCommas(gdt.getNumericValue()); | |
| grNew.insert(); | |
| } | |
| |
| function AddCommas(x) | |
| { | |
| x = x.toString(); | |
| var pattern = /(-?\d+)(\d{3})/; | |
| while (pattern.test(x)) | |
| x = x.replace(pattern, "$1,$2"); | |
| return x; | |
| } | |
| ]]></script><sys_class_name>sys_script_include</sys_class_name><sys_created_by>ggb0926</sys_created_by><sys_created_on>2023-08-23 14:28:08</sys_created_on><sys_id>5c0bb7021b307d10c4fec913604bcba7</sys_id><sys_mod_count>28</sys_mod_count><sys_name>UserLog</sys_name><sys_package display_value="Global" source="global">global</sys_package><sys_policy/><sys_scope display_value="Global">global</sys_scope><sys_update_name>sys_script_include_5c0bb7021b307d10c4fec913604bcba7</sys_update_name><sys_updated_by>ggb0926</sys_updated_by><sys_updated_on>2023-09-29 20:32:29</sys_updated_on></sys_script_include></record_update></payload> | |
| <payload_hash>-659910409</payload_hash> | |
| <remote_update_set display_value="JWJ-User Log Complete-2025 MAIN">6cfe846497075a9035e97666f053afa7</remote_update_set> | |
| <replace_on_upgrade>false</replace_on_upgrade> | |
| <sys_created_by>jwj0215</sys_created_by> | |
| <sys_created_on>2025-01-08 18:09:28</sys_created_on> | |
| <sys_id>24fe8ca497075a9035e97666f053afa2</sys_id> | |
| <sys_mod_count>0</sys_mod_count> | |
| <sys_recorded_at>1944713f9c00000001</sys_recorded_at> | |
| <sys_updated_by>jwj0215</sys_updated_by> | |
| <sys_updated_on>2025-01-08 18:09:28</sys_updated_on> | |
| <table/> | |
| <target_name>UserLog</target_name> | |
| <type>Script Include</type> | |
| <update_domain>global</update_domain> | |
| <update_guid>511d04e0cf075a908560cc73d782876a</update_guid> | |
| <update_guid_history>511d04e0cf075a908560cc73d782876a:-659910409,e631374ad6697d1076c7aa395efbbac3:-659910409,9f105633f99df5d0d5d068d318bc186b:746761500,69ff0effed5df5d0d2404665c6a927c5:425894115,7b23468d5609751040c99bb71f90079e:746761500,86e3f41e7d747d100034f8e43c93259a:801145208,3a53f41edd747d1047f313b208395262:-1176174326,1b13fcda16747d1069847e9e809bd66b:-1924883576,3ac2f0daa4747d10e6ea4ebfe06bfc7e:635433231,5c92fc1a03747d107e0c11eb5e8f9b8a:-198830838,ed02781a8d747d102b6d8a83c49a86cf:-1251918806,5851f0d679747d10881179a30abd44e8:-994192564,69a0f0d6c0747d1078e593d7e39320de:-533151735,a160b092ae747d1089f33ea8968071e9:1663100712,5e9e68d201747d10ade05de7b3cf540b:-266533023,565e6c5200747d10f637492c06f6a0e2:1237008545,efdc6412c1747d10d5c130e864255028:-1062285093,125cecde5f347d10c90e151f3f9593f2:615817525,bb5a2c1e37347d108e7b8677639ca6be:1513215399,c33ae41e97347d10a9f6b966e3f98ed4:-1504258644,130a60d6b3347d1004d79d4977ad3831:1513215399,37b6e896ef347d10d97df43975547b50:-2078997330,af86e89614347d10614a9ab3e0b9db47:2003781621,4ab4e4d293347d1014ba1191ccdcf059:-1130679203,07a4e0926a347d1043d8f9f019c1b606:-641481159,f034a852de347d104478635ed7779755:1126886878,f753a41245347d10f20481d15bee3bf0:637688834,e27228de52f07d101e9a998f2c189c56:-769840912,84e1e49efcf07d107e5dedfcbeaf6bec:-1461265752,500bb7024f307d10a32720e3370fbfaa:-321887211,e5582205bc417510e28b1e0c55ed61b1:-718858164,79499e78e105f110c8dbbf8bcf522c52:746761500,f53916784b05f110957d92bb71c4a9e9:-163217156,a9a85af40705f11051b736ad8da97204:-462089935</update_guid_history> | |
| <update_set display_value=""/> | |
| <view/> | |
| </sys_update_xml> | |
| <sys_update_xml action="INSERT_OR_UPDATE"> | |
| <action>INSERT_OR_UPDATE</action> | |
| <application display_value="Global">global</application> | |
| <category>customer</category> | |
| <comments/> | |
| <name>sys_dictionary_u_log_u_timestamp</name> | |
| <payload><?xml version="1.0" encoding="UTF-8"?><record_update><sys_dictionary action="INSERT_OR_UPDATE" element="u_timestamp" table="u_log"><active>true</active><array>false</array><attributes/><audit>false</audit><calculation><![CDATA[(function calculatedFieldValue(current) { | |
| |
| // Add your code here | |
| return ''; // return the calculated value | |
| |
| })(current);]]></calculation><choice/><choice_field/><choice_table/><column_label>Timestamp</column_label><comments/><create_roles/><default_value/><defaultsort/><delete_roles/><dependent/><dependent_on_field/><display>false</display><dynamic_creation>false</dynamic_creation><dynamic_creation_script/><dynamic_default_value/><dynamic_ref_qual/><element>u_timestamp</element><element_reference>false</element_reference><foreign_database/><formula/><function_definition/><function_field>false</function_field><internal_type display_value="String">string</internal_type><mandatory>false</mandatory><max_length>43</max_length><name>u_log</name><next_element/><primary>false</primary><read_only>false</read_only><read_roles/><reference/><reference_cascade_rule/><reference_floats>false</reference_floats><reference_key/><reference_qual/><reference_qual_condition/><reference_type/><spell_check>false</spell_check><staged>false</staged><sys_class_name>sys_dictionary</sys_class_name><sys_created_by>ggb0926</sys_created_by><sys_created_on>2023-08-31 20:13:42</sys_created_on><sys_id>5995d6709705f1103e1432890353af2f</sys_id><sys_name>Timestamp</sys_name><sys_package display_value="Global" source="global">global</sys_package><sys_policy/><sys_scope display_value="Global">global</sys_scope><sys_update_name> |
