Query knowledge articles based on Qwnership groups

[DivyaNarayG]

I am trying to retrive the list of knowledge articles owned by the support groups the logged in user is part of,

but I am getting an empty result. Please correct my mistake

var ka_group = gs.getUser().getMyGroups();

var gr = new GlideRecord('kb_knowledge');

gr.addQuery('ownership_group','IN',ka_group) ; 

gr.query();

while(gr.next())

{

gs.info(gr.article_id);

}

[CezaryBasta]

getMyGroups returns an iterator, so you have to cast it to an array and then join it to use it in your query. See the documentation for an example.

[Arathi Jyothind]

Hi,

Maybe, try with encoded query? Below code worked for me.

var ka_group = gs.getUser().getMyGroups();

var gr = new GlideRecord('kb_knowledge');

gr.addEncodedQuery('ownership_groupIN'+ ka_group) ;

gr.query();

while(gr.next())

{

gs.info(gr.article_id);

}

[dgarad]

Hi @DivyaNarayG 

try the below code.

var ka_group = gs.getUser().getMyGroups();

var gr = new GlideRecord('kb_knowledge');
gr.addQuery('ownership_group',ka_group.join()) ; 
gr.query();
while(gr.next())
{
gs.print(gr.article_id);
}

[swathisarang98]

Hi @DivyaNarayG ,

I tried this in my pdi the below code is working i have made few changes to your code,

var groupMember = new GlideRecord('sys_user_grmember');
groupMember.addQuery('user',gs.getUserID());
//var arr = [];
groupMember.query();
while(groupMember.next()){
//arr.push(groupMember.getValue('group'));
var gr = new GlideRecord('kb_knowledge');
gr.addQuery('ownership_group',groupMember.getValue('group')) ;
gr.query();
while(gr.next())
{

gs.info(gr.number + ' ' + 'Ownership group: ' + gr.getDisplayValue('ownership_group') ); // gr.number written KB number,u

}
}

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang