global
Global
global
This DCM addon includes two Relationships between Unique Audit Messages and the Global table.
One is created based on the Real Record (Document ID) and another based on the Audited Record (Document ID) references. This allows adding a list of Open Unique Audit Messages to any form layout.
DCM Add-on - Relate Unique Audit Messages to Global table v1.1
ccaacf7baf4e1150c7fec05e653b5679
loaded
sys_remote_update_set
mj@dcm.fi
2022-09-27 08:30:22
027ccffbaf4e1150c7fec05e653b567b
0
mj@dcm.fi
2022-09-27 08:30:22
INSERT_OR_UPDATE
global
customer
sys_relationship_5101a1021bda78108063ff7e034bcbce
<?xml version="1.0" encoding="UTF-8"?><record_update table="sys_relationship"><sys_relationship action="INSERT_OR_UPDATE"><advanced>false</advanced><apply_to/><basic_apply_to>global</basic_apply_to><basic_query_from>x_jugr_dcm_unique_audit_message</basic_query_from><insert_callback/><name>Open Audit Messages (DCM Real Record)</name><query_from/><query_with><![CDATA[(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
current.addQuery('real_record',parent.sys_id.toString());
current.addEncodedQuery('status=open');
})(current, parent);]]></query_with><reference_field>audit_instance</reference_field><related_list/><simple_reference>false</simple_reference><sys_class_name>sys_relationship</sys_class_name><sys_created_by>mj@dcm.fi</sys_created_by><sys_created_on>2021-09-01 08:05:16</sys_created_on><sys_id>5101a1021bda78108063ff7e034bcbce</sys_id><sys_mod_count>2</sys_mod_count><sys_name>Open Audit Messages (DCM Real Record)</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_relationship_5101a1021bda78108063ff7e034bcbce</sys_update_name><sys_updated_by>mj@dcm.fi</sys_updated_by><sys_updated_on>2022-09-27 08:29:25</sys_updated_on></sys_relationship><sys_translated_text action="delete_multiple" query="documentkey=5101a1021bda78108063ff7e034bcbce"/></record_update>
-452923370
027ccffbaf4e1150c7fec05e653b567b
false
mj@dcm.fi
2022-09-27 08:30:22
467ccffbaf4e1150c7fec05e653b567b
0
1837e10addf0000001
mj@dcm.fi
2022-09-27 08:30:22
Open Audit Messages (DCM Real Record)
Relationship
global
144ccbfbf64e11507cec1f6193553141
144ccbfbf64e11507cec1f6193553141:-452923370,715321c6beda7810b0889ba7b6592f1d:1122913540,5611690604da7810e21af1605e5a940e:-618122472
INSERT_OR_UPDATE
global
customer
sys_relationship_7231a5461bda78108063ff7e034bcb33
<?xml version="1.0" encoding="UTF-8"?><record_update table="sys_relationship"><sys_relationship action="INSERT_OR_UPDATE"><advanced>false</advanced><apply_to/><basic_apply_to>global</basic_apply_to><basic_query_from>x_jugr_dcm_unique_audit_message</basic_query_from><insert_callback/><name>Open Audit Messages (DCM Audited Record)</name><query_from/><query_with><![CDATA[(function refineQuery(current, parent) {
// Add your code here, such as current.addQuery(field, value);
current.addQuery('audited_record',parent.sys_id.toString());
current.addEncodedQuery('status=open');
})(current, parent);]]></query_with><reference_field>audit_instance</reference_field><related_list/><simple_reference>false</simple_reference><sys_class_name>sys_relationship</sys_class_name><sys_created_by>mj@dcm.fi</sys_created_by><sys_created_on>2021-09-01 08:05:51</sys_created_on><sys_id>7231a5461bda78108063ff7e034bcb33</sys_id><sys_mod_count>2</sys_mod_count><sys_name>Open Audit Messages (DCM Audited Record)</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_relationship_7231a5461bda78108063ff7e034bcb33</sys_update_name><sys_updated_by>mj@dcm.fi</sys_updated_by><sys_updated_on>2022-09-27 08:28:54</sys_updated_on></sys_relationship><sys_translated_text action="delete_multiple" query="documentkey=7231a5461bda78108063ff7e034bcb33"/></record_update>
-781269957
027ccffbaf4e1150c7fec05e653b567b
false
mj@dcm.fi
2022-09-27 08:30:22
8e7ccffbaf4e1150c7fec05e653b567b
0
1837e1035820000001
mj@dcm.fi
2022-09-27 08:30:22
Open Audit Messages (DCM Audited Record)
Relationship
global
b42c0bfbab4e115077f01523aa900dd2
b42c0bfbab4e115077f01523aa900dd2:-781269957,0b33a5c6bdda781079380dfe1857a142:1600111455,f631a54692da78104a1e07dfb3e19534:280469558