Based upon assignment group, category fields to show dynamically

[snavuluri]

Create a category- assignment group mapping table and write client script and script include to handle the show hide if the category, if assignment group is not "software", category and subcategory related to software are not supposed to show up in the incident form.

[snavuluri]

HI,

      I thank you for your reply. The above one is not usefull for me and i have completed solved the issue. Thank You once again.

Regards,

Suresh N

[deepa]

Create a reference field named 'Assignment group manager' referring to sys_user table on the incident form.
Place it next to assignment group field in the form.
After you update the form with group value in assignment group field,the related group's manager value must be displayed on the 'Assignment group manager' field.

how to do this

var ass_group = current.assignment_group;
var gr = new GlideRecord("sys_user_group");
gr.addQuery("sys_user",ass_group);
gr.query();
if(gr.next())
{
var manager = gr.assignmentgroupmanager;
current.u_assignment_group_manager=manager;
}

it didnt worked