How to populate a field on the the sys_user_group based on another field in the sys_user_grou via BR

[Daniel R2]

Hi,

On the sys_user_group form we have added a custom field called 'Display Name'
This is due to the fact that the name is to complex and we would prefer a more understandable display name.

There is a requirement to populate the custom field 'Display Name' based on the 'Name' field on the sys_user_group form through a Business Rule. 

(The reason for this configuration, is due to a previous integration which has imported the necessary groups. So if more groups get loaded in the future, this Business Rule should organise it. We would also like a better dislplay name, as already mentioned above)

For e.g. 

• If the "Name" field starts with "ABC-Random_ABCD-ServiceNow_AB_" it should be cut and the remaining text should be the "Display name"
• Otherwise "Name" should be copied fully to "Display name".

Is it possible if someone can please provide their support here or provide a script that would allow this to work. 

[priyasunku · Accepted solution]

Hi @Daniel R2 

You can try below Before Business Rule 

var Name = current.name;    

    var Name_length = Name.toString().length;

    if(Name.contains('ABC-Random_ABCD-ServiceNow_AB_'));

    {

        var display_name = Name.substring(30,Name_length);

        current.u_display_name=display_name;

    }

    else

 current.u_display_name=Name;

Please let me know if this helpful.

[Daniel R2]

@priyasunku - This works perfectly thank you! Before i accept the solution, i have one other question.

We have around 130 groups that need updating, what background script can we run to update these automatically, instead of going through each one updating them manually?

[priyasunku]

Hi @Daniel R2 

please try below code to run in backround script

var gr = new GlideRecord('sys_user_group');

gr.addQuery('name' 'CONTAINS' 'ABC-Random_ABCD-ServiceNow_AB_');

gr.query();

while(gr.next())

{

var Name = gr.name;    

    var Name_length = Name.toString().length;

        var display_name = Name.substring(30,Name_length);

        gr.u_display_name=display_name;

    }

Please try this and <mrak answer as helpful if this solves the issue

[Daniel R2]

Thanks again @priyasunku for the reply. I have just tested this, but it doesnt seem to be working. The records are not updating automatically
Error that we can see is: 'Unexpected Token 'CONTAINS'

[priyasunku]

please try this

var gr = new GlideRecord('sys_user_group');
gr.addQuery('name', "CONTAINS" ,"ABC-Random_ABCD-ServiceNow_AB_");
gr.query();

while(gr.next())

{

var Name = gr.name;
var Name_length = Name.toString().length;
var display_name = Name.substring(30,Name_length);
gr.u_display_name=display_name;
gr.update();
}