Knowledge Manager field autopopulate in Knowledge base form

[Atchutaram]

Hi Team,

                 I have been working on Kb's and i want to write  a business rule like, we do have Approvers group field on Knowledge base form and Manager's field. I want to auto populate the names of the user's who are part of approvers group in Manager field on Knowledge base form.

we have around four bases. how can we do it.

And when ever a user is added or removed from group it should reflect in KB form.

How can i do this?

[Dr Atul G- LNG]

Hi @Atchutaram 

I did not find approver field on base level. Is it custom?

[Atchutaram]

For example, we do have one group approver for every knowledge base based on the flow, i want to get the group members in that manager field(which is of list type) on knowledge base form.

I want to get the group members in that manager field.

[Basheer]

Hi @Atchutaram 

Here you need to create the manager field type as list.

You should write a business rule on sys_user_grmember (Group Members) table with insert, update and delete
In the code you need to write as below 

var user = current.user;
var group = current.group;
var manager = " ";

var kbRecord = new GlideRecord("Your kb table name");
kbRecord.addQuery("Approvers group field name", group);
kbRecord.query();
While(kbRecord.next()){
if(current.action == "insert" || current.action == "update"){
kbRecord.manager = kbRecord.manager+","+ KbRecord.user;
}
else{
kbRecord.manager = kbRecord.manager.(Do your remove operation accrodingly)
}
kbRecord.update();
}

Please mark correct, if this has solved your problem.

Please mark helpful, if this has helped you in any way.

[Atchutaram]

Hi Basheer,

                      Will this work when i want to autopopulate the group members names in that manager filed? as we do have different knowledge bases for every knowledge base will this work? 

in the second line of code where you mentioned "approvers group field name" should i give the sys_id of the group i wanted to autopopulate?