logo

NJP

Search Term Results

Import · Oct 20, 2020 · article

A quick script that can be used to return the score of a search term on a given instance.

This script is only set up to run on the Catalog and Knowledge tables.

adjust the query as needed for your instance.

run it as a fix script.

var qSet = "leave,maternity";


var q = qSet.split(",");
var message = "";
q.sort();

for (var i=0;i<q.length;i++)
{

    message =  message + "\n~~" + q[i];

    var sc = new GlideRecord('sc_cat_item');
    sc.addQuery('123TEXTQUERY321', q[i]);
    sc.addQuery('active',true);
    sc.addQuery('sys_class_name', 'NOT IN', 'sc_cat_item_wizard,sc_cat_item_content');
    sc.query();
    message =  message + "\n~~~~ FORMS RESULTS " + q[i] + "("+ sc.getRowCount() +")";
    while (sc.next()) 
    {
        message = message + "\n~~~~~~~~ " +  sc.ir_query_score   + " " + sc.name;   
    }

    var kb = new GlideRecord('kb_knowledge');
    kb.addQuery('123TEXTQUERY321', q[i]);
    kb.addQuery('workflow_state', 'published');
    kb.addNotNullQuery('text'); // tier 0 ans
    kb.setLimit(20);
    //kb.addQuery(getAgencyName(), true);
    kb.query();
    message =  message + "\n~~~~ KNOWLEDGE RESULTS " + q[i] + "("+ kb.getRowCount() +")";
    while (kb.next()) 
    {
        message = message + "\n~~~~~~~~ " +  kb.ir_query_score   + " " + kb.number + " " + kb.short_description;    
    }   
}


gs.log(message,"raymond");

View original source

https://www.servicenow.com/community/developer-articles/search-term-results/ta-p/2320709