Business rule help - gliderecord

[Andrew_TND]

Hello, just need some scripting help.

I've created a custom table to store "personas" and each one has a department assigned.

What I'm trying to achieve is if the department on the u_personas table matches the department on the user profile it will update the record with matching persona in field u_persona.

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

    var persona = new GlideRecord("u_persona");
    persona.addQuery("department", current.getDisplayValue("department"));
    persona.query();
   while (persona.next());
    if (persona.department == current.getDisplayValue("department")) {
        current.u_software == persona.sys_id;
    }

})(current, previous);

[Andrew_TND]

Thank you, tried both before and after but doesnt work.

[manjusha_]

@Andrew_TND 

You want update u_software field of user profile if department matches?

if above is your requirement ,try my code 

Share screenshot if it does not work

Thanks,

Manjusha Bangale

[Satyapriya]

Hi Andrew Robinso1,

Please confirm that u_software is a reference field or not.

[Andrew_TND]

Hi, yes its referened to the u_persona table.

[Vishal Birajdar]

Hi @Andrew_TND 

What is the type of department field in u_persona table.

Also please check if its backend value is department or u_department as its a custom table field.

If its a reference field then you need to update your query

persona.addQuery("department",current.getValue("department");

Also can you tell us on which table this script is running...??