Selective Hiding: Domain Separation for List Data

Domain separation is the technique by which we let users view only a selective range of data. The data visibility is defined by the domain in which the user is residing and we add a similar column to our concerned table as Domain. The filtering is done by ServiceNow by matching the domains and letting a user view only the data that falls into his domain,

For this, what we may do as an advanced step is separating the users based on their company and adding a Company field in our table which will decide the domain view. I'll tell you how!!

First, create a column named domain....do not save before you read this fully. Column type will be Domain as well. Change the column name from u_domain to sys_domain before you save anything.

After you'll save, ServiceNow will create a column named Domain Path for its reference. Now, all you need to do is convert your Company name to Domain. For this, we will be writing a Business Rule which will run before Insert and Update.

Below is the script you need to add in Advanced tab -

var defdomain = current.u_company; //the value from company field - sys_id since it is a ref field

var chgdomain = ""; //variable to store domain value

var compcheck = new GlideRecord('core_company');

compcheck.addQuery('sys_id', defdomain); //find the record of the company

compcheck.query();

if (compcheck.next()) {

chgdomain = compcheck.sys_domain.getDisplayValue(); //get the domain value from company table

}

updatesoftdomain();

function updatesoftdomain()

{

current.sys_domain = chgdomain;

current.update();

}

Done Done Done...!! :)