Hi Maik, sorry for the confusion, as in I have three custom related list tables that will appear based on the fields selected in the risk event form, so this part is configured using UI Policy. But to make a related list mandatory for my knowledge here is the only way is to use Business Rule before insert or before update right? So that is where this Business Rule questioned came up, currently this is my business rule script.
(function executeRule(current, previous /*null when async*/) {
// Get the selected party
var partyValue = current.u_parties_involved_in_affected_by_the_event;
// If party value is empty, do nothing
if (!partyValue)
return;
// If 1 or 3, check for Customer Involved
if (partyValue == 1 || partyValue == 3) {
var customer = new GlideRecord("sn_risk_advanced_customer_info_breached_customer_s_involved_affected");
customer.addQuery("u_risk_event", current.sys_id);
customer.query();
if (!customer.next()) {
gs.addInfoMessage("Please add at least one Customer Involved record.");
action.setRedirectURL(current);
current.setAbortAction(true);
return;
}
}
// If 2, check for Staff
if (partyValue == 2) {
var staff = new GlideRecord("sn_risk_advanced_customer_info_breached_staff");
staff.addQuery("u_risk_event", current.sys_id);
staff.query();
if (!staff.next()) {
gs.addInfoMessage("Please add at least one Staff record.");
action.setRedirectURL(current);
current.setAbortAction(true);
return;
}
}
// If 3, also check for Third Party
if (partyValue == 3) {
var thirdParty = new GlideRecord("sn_risk_advanced_customer_info_breached_third_party_service_provider");
thirdParty.addQuery("u_risk_event", current.sys_id);
thirdParty.query();
if (!thirdParty.next()) {
gs.addInfoMessage("Please add at least one Third Party Service Provider record.");
action.setRedirectURL(current);
current.setAbortAction(true);
return;
}
}
})(current, previous);
