Hi @prasannasun ,
you can try with this using advanced reference qualifier by using script include.
do the following
1. Create one script include
Script include :
Name: KBUserCriteriaUtils
var KBUserCriteriaUtils = Class.create();
KBUserCriteriaUtils.prototype = {
initialize: function() {
},
getContributableKnowledgeBases: function() {
var userSysId = gs.getUserID();
var kbSysIds = [];
var grUserCriteria = new GlideRecord('kb_uc_can_contribute_mtom');
grUserCriteria.addQuery('user_criteria.active', true);
grUserCriteria.query();
while (grUserCriteria.next()) {
var ucSysId = grUserCriteria.getValue('user_criteria');
var uc = new GlideUserCriteria();
if (uc.evaluate(ucSysId, userSysId)) {
// Now find all knowledge bases associated with this user criteria.
var grKB = new GlideRecord('kb_knowledge_base');
grKB.addActiveQuery();
grKB.addQuery('can_contribute_user_criteria', ucSysId);
grKB.query();
while (grKB.next()) {
kbSysIds.push(grKB.getUniqueValue());
}
}
}
// Also include KBs with no user criteria for 'can_contribute' (public).
var grPublicKB = new GlideRecord('kb_knowledge_base');
grPublicKB.addActiveQuery();
grPublicKB.addNullQuery('can_contribute_user_criteria');
grPublicKB.query();
while (grPublicKB.next()) {
kbSysIds.push(grPublicKB.getUniqueValue());
}
var uniqueKBIds = new ArrayUtil().unique(kbSysIds);
return 'sys_idIN' + uniqueKBIds.join(',');
},
type: 'KBUserCriteriaUtils'
};
2. Open the field called 'u_knowledge_base', add reference qualifier like below
javascript:new KBUserCriteriaUtils().getContributableKnowledgeBases();
then try to test the logic. it will filter the Knowledge Base, where user can contribute and also public Knowledge Base
If this information proves useful, kindly mark it as helpful or accepted solution.
Thanks,
BK
