Get value of "User role" type field

monika94 · ‎12-13-2017

Hi All,

Quick question. How can I get value of Roles field (type is-User Role) on sc_cat_item table using client script. getValue() returns nothing.

Thank you.

Monika

Brent Sutton · ‎12-13-2017

Hi Monika,

If the the client script is being run on the sc_cat_item form then you could use the following code to return the comma separated list of roles in the user_role field (I've got it as an onLoad script but you can utilise it as required): -

function onLoad() {

     //Type appropriate comment here, and begin script below


         var sysID = g_form.getUniqueValue();

         var table = g_form.getTableName();


         var gr = new GlideRecord(table);


         if(gr.get(sysID)){

                   var roles = gr.getValue('roles');

                   g_form.addInfoMessage('Roles: ' + roles);

         }

}

This may be a good candidate for GlideAjax if you want the users to be able to continue while this query is being processed. All depends on your use case.

Hope this helps.

View solution in original post

monika94 · ‎01-01-2018

We are using this for Reporting purpose.