\$sp.getRecordDisplayValues equivalent in client script

[SNnewbie2]

I want to know the equivalent of this line of code

$sp.getRecordDisplayValues(article, kb, 'sys_id,number,short_description,published,text');

article.url = "/" + portal.url_suffix + "?id=kb_article&sys_id=" + kb.getUniqueValue();

article.publishedUTC = kb.getValue('published');

article.type = "kb";

in a client script for a service portal.

Thank you

[Brad Tilton]

Hi Claudia,

I don't believe we have a client side equivalent, but you should be able to write any data to the data object in the server script section of the widget and access it from the client section.

[SNnewbie2]

Thank you for your response. I am new to SP so things get complicated for me. I am hoping to migrate part of my code from my search source to my client script in my widget. I have a server script:

(function() {
data.searchType = $sp.getParameter("t");
data.results = [];
data.searchMsg = gs.getMessage("Search");
data.limit = options.limit || 15;
var textQuery = '123TEXTQUERY321';


if (!input) {
data.typeaheadTemplates = {};


var searchGroupTemplatesGR = new GlideRecord("sp_search_source");
searchGroupTemplatesGR.query();
while(searchGroupTemplatesGR.next()) {
if (searchGroupTemplatesGR.getElement("advanced_typeahead_config").getDisplayValue() == "true")
data.typeaheadTemplates["sp-typeahead-" + searchGroupTemplatesGR.getValue("id") + ".html"] = $sp.translateTemplate(searchGroupTemplatesGR.getValue("typeahead_template"));
}


return;
}


data.q = input.q;


//Gotta decide if we want to use the portal's sources, or use the defaults declared by
//the sys property
var useDefaultPortals;
if (!$sp.getPortalRecord()) {
useDefaultPortals = true;
} else {
var searchSourcesForPortalGR = new GlideRecord("m2m_sp_portal_search_source");
searchSourcesForPortalGR.addQuery("sp_portal", $sp.getPortalRecord().getUniqueValue());
searchSourcesForPortalGR.query();
useDefaultPortals = searchSourcesForPortalGR.getRowCount() == 0;
}
$sp.log(useDefaultPortals);




if (useDefaultPortals) {
var defaultSearchSourceGR = new GlideRecord("sp_search_source");
var defaultSearchSourceIDList = gs.getProperty("glide.service_portal.default_search_sources", "");
defaultSearchSourceGR.addQuery("sys_id", "IN", defaultSearchSourceIDList);
defaultSearchSourceGR.addQuery("enable_typeahead", true);
defaultSearchSourceGR.query();
while(defaultSearchSourceGR.next()) {
getResults(defaultSearchSourceGR);
}
} else {
var m2mSearchSourceGR = new GlideRecord("m2m_sp_portal_search_source");
m2mSearchSourceGR.addQuery("sp_search_source.enable_typeahead", true);
m2mSearchSourceGR.addQuery("sp_portal", $sp.getPortalRecord().getUniqueValue());
m2mSearchSourceGR.query();
while(m2mSearchSourceGR.next()) {
getResults(m2mSearchSourceGR.getElement("sp_search_source").getRefRecord());
}
}


function getResults(gr) {
if (gr.is_scripted_source) {
var input = {};
input.query = data.q;
var evaluator = new GlideScopedEvaluator();
var results = evaluator.evaluateScript(gr, "data_fetch_script", input);


results.forEach(function(item) {
if (gr.getElement("advanced_typeahead_config").getDisplayValue() == "true")
item.templateID = "sp-typeahead-" + gr.getValue("id") + ".html";
else {
item.glyph = gr.getValue("typeahead_glyph");
item.linkToPage = gr.getValue("page");
}
data.results.push(item);
});
} else {
var primaryField = gr.getValue("primary_display_field");
var displayFields = gr.getValue("display_fields");


var resultGR = new GlideRecordSecure(gr.getValue("source_table"));
var condition = gr.getValue("condition");
if (condition)
resultGR.addEncodedQuery(condition);
if (data.q)
resultGR.addQuery('123TEXTQUERY321', data.q);
resultGR.query();


var searchTableCount = 0;
while (resultGR.next() && searchTableCount < data.limit) {
if (!resultGR.canRead())
continue;


var secondaryValues = {};


if (displayFields)
displayFields.split(",").forEach(function(field) {
var obj = getField(resultGR, field);
secondaryValues[field] = obj;
});


var item = {
primary: (primaryField) ? resultGR.getValue(primaryField) : resultGR.getDisplayValue(),
sys_id: resultGR.getUniqueValue(),
table: resultGR.getTableName(),
fields: secondaryValues
};


if (gr.getElement("advanced_typeahead_config").getDisplayValue() == "true")
item.templateID = "sp-typeahead-" + gr.getValue("id") + ".html";
else {
item.glyph = gr.getValue("typeahead_glyph");
item.linkToPage = gr.getValue("page");
}


data.results.push(item);
searchTableCount++;
}
}


var pageGR = new GlideRecord("sp_page");
if (pageGR.get(gr.getValue("page")))
var pageID = pageGR.getValue("id");


data.results.forEach(function(result) {
if (result.url)
return;


if (pageID) {
result.url = "?id=" + pageID;
if (result.sys_id)
result.url += "&sys_id=" + result.sys_id;
if (result.table)
result.url += "&table=" + result.table
} else {
result.url = "";
}
});
$sp.log(data.results);
}




function getField(gr, name) {
var f = {};
f.display_value = gr.getDisplayValue(name);
f.value = gr.getValue(name);
var ge = gr.getElement(name);
if (ge == null)
return f;


f.type = ge.getED().getInternalType()
f.label = ge.getLabel();
return f;

}

})();

I want to be able to translate this part of my code from my search source to my client script of my widget :

(function(query) {
var results = [];
//Here goes the logic. Compute results however you want!
var kb = new GlideRecord('kb_knowledge');
data.limit = 3;
var knowledgeOrder = 0;
kb.setLimit(data.limit);
kb.addQuery('123TEXTQUERY321', query);
kb.addQuery('topic','=', 'Service Description');
kb.query();
data.article_count = kb.getRowCount();

gs.console("hello");
// items are sorted by score. All results are sorted together by the score even across search sources
// to see the score add score: {{match.model.score}} to the template on the typeahead tab

var kbCount = 0;
while (kb.next() && kbCount < data.limit) {
// Does user have permission to see this item?
if (!$sp.canReadRecord("kb_knowledge", kb.getUniqueValue()))
continue;

if(kbCount == 0){
results.push({header:true, score: knowledgeOrder, url: '#', primary: ''});
}

var portal = $sp.getPortalRecord();

var article = {};
$sp.getRecordDisplayValues(article, kb, 'sys_id,number,short_description,published,text');
article.url = "/" + portal.url_suffix + "?id=kb_article&sys_id=" + kb.getUniqueValue();
article.publishedUTC = kb.getValue('published');
article.type = "kb";
if (!article.text)
article.text = "";
article.text = $sp.stripHTML(article.text) + "";
article.text = article.text.substring(0, 200);
article.score = knowledgeOrder - kbCount; //parseInt(kb.ir_query_score.getDisplayValue());
article.label = article.short_description;
article.primary = article.short_description;
results.push(article);
kbCount++;
if(kbCount == data.limit){
var seeAllLink = "/" + portal.url_suffix + "?id=search&t=&q=" + query +"&search=";
results.push({seeAllLink:true, score: knowledgeOrder - kbCount, url: seeAllLink, primary: ''});
}
}
$sp.logSearch('kb_knowledge', data.q, kb.getRowCount());


return results;
})(query);