updating the field value using business rule

[2022_ServiceNow]

Hi, I have a business rule which runs on one of the table.

This script is updating the department based on the managed by.

But not updating the 'u_managed' based on the condition.

The condition should be if department contains 'IT' then update 'u_managed' to 'IT' otherwise 'xyz'

(function executeRule(current, previous /*null when async*/ ) {

    var ao = current.managed_by;
    if (ao) {
        var userGr = new GlideRecord('sys_user');
        userGr.get(ao );
        current.department= userGr.department;
    }
    if (current.department && department.toLowerCase().indexOf('it') != -1) {
        current.u_managed = 'IT';
    } else {
        current.u_managed = 'xyz';
    }
})(current, previous);

 @Ankur Bawiskar @Amit Gujarathi 

[Amit Gujarathi · Accepted solution]

HI @2022_ServiceNow ,
I trust you are doing great.
Please find below updated code for the same

(function executeRule(current, previous /*null when async*/) {

    var ao = current.managed_by;
    if (ao) {
        var userGr = new GlideRecord('sys_user');
        userGr.get(ao);
        current.department = userGr.department;
    }
    
    // Ensure that the department value is not null before performing string operations
    if (current.department) {
        // Convert the department value to lowercase and check if it contains 'it'
        if (current.department.toLowerCase().indexOf('it') != -1) {
            current.u_managed = 'IT';
        } else {
            current.u_managed = 'xyz';
        }
    }

})(current, previous);

[2022_ServiceNow]

@Ankur Bawiskar It is on the cloud application table. It should run on insert and update before the managed by changes.

When 'managed_by' changes, it should change the department according to the department of the 'managed_by'. This is working. 

Now if the department contains 'IT', then the field 'u_managed' should change to 'IT' otherwise another value.

[Ankur Bawiskar · Accepted solution]

@2022_ServiceNow 

update as this and it will work fine

(function executeRule(current, previous /*null when async*/) {

	var ao = current.managed_by;
	if (ao) {
		var userGr = new GlideRecord('sys_user');
		userGr.addQuery('sys_id', ao);
		userGr.addQuery('department.name', 'LIKE', 'it');
		userGr.query();
		if(userGr.hasNext())
			current.u_managed = 'IT';
		else 
			current.u_managed = 'xyz';
	}

})(current, previous);

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@2022_ServiceNow 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Amit Gujarathi · Accepted solution]

HI @2022_ServiceNow ,
I trust you are doing great.
Please find below updated code for the same

(function executeRule(current, previous /*null when async*/) {

    var ao = current.managed_by;
    if (ao) {
        var userGr = new GlideRecord('sys_user');
        userGr.get(ao);
        current.department = userGr.department;
    }
    
    // Ensure that the department value is not null before performing string operations
    if (current.department) {
        // Convert the department value to lowercase and check if it contains 'it'
        if (current.department.toLowerCase().indexOf('it') != -1) {
            current.u_managed = 'IT';
        } else {
            current.u_managed = 'xyz';
        }
    }

})(current, previous);