Show untranslated and translated KB articles

[_lcrsrms_]

Hi, Community.

We have a requirement to show KB articles based on user's preferred language. We have achieved this by disabling system property glide.knowman.enable_multi_language_search, and by cloning and modifying OOB widgets KB Most Viewed and KB Top Rated.

However, our client came back to us that they wanted to have both translated (in user's preferred language) and untranslated (in English) articles to be available for the users.

By achieving that, we've re-enabled glide.knowman.enable_multi_language_search. However, I'm not able to found the solution modifying the server script to show both articles in English and user's preferred language. Can someone help to modify these code to achieve that? Will follow the solution to other widgets once verified. Thanks in advance!!

Tried adding line of scripts:

var userPreferredLanguage = gs.getUser.getLanguage(); and add it to article's query condition to show both language in 'en' and user's preferred language but it's not working.

(function() {
	
	//Get Knowledge Base Id. If knowledge base is not selected, get knowledge bases associated with portal.
	data.kb = "";
	data.kb_id = $sp.getParameter("kb_id");
	data.show = false;
	if (data.kb_id) {
		var kbArr = [];
		var kbGR = new GlideRecord("kb_knowledge_base");
		kbGR.addQuery("sys_id", "IN", data.kb_id);
		kbGR.query();
		while (kbGR.next()) {
			if (kbGR.canRead())
				kbArr.push(kbGR.getUniqueValue());
		}
		data.kb = String(kbArr);
	} else
		data.kb = String($sp.getKnowledgeBases());
	
	//To support Show more functionality
	var loadCategories = options.number_of_categories_to_load || 15;
	data.showMoreMsg = gs.getMessage("Show More");
	data.pleaseWait = gs.getMessage("Please wait... fetching categories");

	var maxArticleLimitForCounts = parseInt(options.max_article_limit_for_counts) || 500;
	var articles = new GlideRecord("kb_knowledge");
	articles.addQuery("kb_knowledge_base", "IN", data.kb);
	articles.addQuery("workflow_state", "published");
	articles.addQuery("valid_to", ">=", new GlideDate().getValue());
	articles.addActiveQuery();
	articles.setLimit(maxArticleLimitForCounts);
	articles.query();

	var kbCount = articles.getRowCount();

  // Get all top-level categories in selected knowledge bases
	var cats = new GlideRecord("kb_category");
	cats.addActiveQuery();
	cats.addQuery("parent_id",'IN', data.kb);
	cats.query();
	
	var categoryId = $sp.getParameter('kb_category');
	var msg = data.messages = {};
	msg.expanded = gs.getMessage("Expanded");
	msg.collapsed = gs.getMessage("Collapsed");

	data.category = {};
	data.categories = [];
  
	//To support Show more functionality
	if (input && input.getMore)
	    loadCategories = loadCategories + parseInt(input.categoriesCount);

	var categoriesCount = 0;
  
	var allTopLevelCategories = [];
	while (cats.next()) {
		var categoryDetails = {};
		categoryDetails.label = cats.getDisplayValue("label");
		categoryDetails.value = cats.getUniqueValue();
		categoryDetails.showChildren = cats.sys_id == categoryId;
		allTopLevelCategories.push(categoryDetails);
	}
	var totalRecords = allTopLevelCategories.length;
	allTopLevelCategories.sort(function (a, b) { return a.label > b.label ? 1 : (a.label < b.label ? -1 : 0) });
	// Get Subcategories and build tree structure
	var index;
	for(index = 0; index < totalRecords; index++) {
		data.categories[index] = getCategory(allTopLevelCategories[index], 0, true);
		//To support Show more functionality
		if (data.categories[index].count !== 0)
			categoriesCount++;
		if (categoriesCount >= loadCategories)
		 	break;
	}
	data.showMore = index < totalRecords - 1;
	data.categoriesCount = categoriesCount;
	data.loadAllMsg = gs.getMessage("Showing {0} categories", [categoriesCount + ""]); 
	data.categoryId = categoryId;
	
	if (data.categoriesCount > 0) {
		data.categories[0].isFirstCategory = true;
	}
	
	options.check_access_per_category = parseInt(options.check_access_per_category);

	function getCategory(cats, level, hasCategoryDetails) {
		var categoryDetails = {};
		var articleCount = -1;
		var arts;
		
		if(!hasCategoryDetails) {
			categoryDetails.label = cats.getDisplayValue("label");
			categoryDetails.value = cats.getUniqueValue();
			categoryDetails.showChildren = cats.sys_id == categoryId;
		} else {
			categoryDetails = cats;
		}
		if (kbCount < maxArticleLimitForCounts) {
			// small KB, get full canRead counts for each category
			arts = $sp.getKBCategoryArticleSummary(categoryDetails.value, 0, 0);
			articleCount = arts.length;
			if (articleCount > 0)
				data.show = true;
		} else if (options.check_access_per_category > 0) {
			// large KB, don't get counts but check first N articles for read access to category
			arts = $sp.getKBCategoryArticleSummary(categoryDetails.value, options.check_access_per_category, 0);
			if (arts.length > 0)
				data.show = true;
			else
				articleCount = 0; // nothing to see here, no visible article found
		} else {
			// large KB, not checking article access before showing category, preserves legacy behavior
			data.show = true;
		}
		
		categoryDetails.count = articleCount;
		categoryDetails.level = level;
		
		var subcategories = new GlideRecord("kb_category");	
		subcategories = $sp.getSubCategories(categoryDetails.value);
		categoryDetails.subcategories = [];
		while (subcategories.next()) {
			var category = getCategory(subcategories, level+1);
			if (category.count != 0) {
				categoryDetails.subcategories.push(category);
				categoryDetails.count += category.count;
			}
			categoryDetails.showChildren = categoryDetails.showChildren || category.showChildren;
		}
		return categoryDetails;
	}
})()