How to show Favorites in the Show Me Everything topics of VA in Employee Center

[kmolson73]

Currently I am aware that the Favorites for Employee Center now reside in the sp_favorite table. I know there is a widget and the users can get to My Favorites by clicking the link on the homepage in ESC. I have a request in to also add the list of favorites in the show me everything link (topics) within the Virtual Agent. So far I have been unable to get it to work. I tried creating a new topic but my script does not bring up the list of the users favorites. I looked at the OOB topic blocks but they use the bookmarks table which contains URL's etc. where as the sp_favorites table only contains the User, reference document and reference table. Any ideas on how I can query that table to form a list of the favorites they can choose from?  

[kmolson73]

So far this is what I have, my topic "My Favorites" has a Dynamic choice where I have the below script. It is showing my favorites when I test it (see attached image) but if I click on a favorite from the choices it doesn't go to the record producer/catalog item or knowledge article. How do I get it to go to the correct record? 

(function execute() {

var options = [];

// get variables

var count = 0;

// query current favorites

var gr = new GlideRecordSecure('sp_favorite');

gr.addQuery('user', vaInputs.user);

gr.orderByDesc('sys_created_on');

gr.query();

// get total count, used for pagination

count = gr.getRowCount();

vaVars.count = count;

// page of favorites

var cnt = 0;

while(gr.next()) {

var value = gr.getUniqueValue();

var label = gr.getDisplayValue('reference_document');

options.push({

'value': value,

'label': label

});

cnt++;

}

return options;

})();