We are implementing Service Portal for deployment next month to production. We are using the Data Table widget to display a list of approval records, but I have run into an issue with the search functionality of this widget. The widget uses the 123TEXTQUERY321 column for keyword searches.
I am finding that the query that is generated by the widget is failing when using the keyword text search field on the widget against the table 'sysapproval_approver'.
I am able to reproduce the empty result set by recreating the query in a back ground script. With the 123TEXTQUERY321 column query condition enabled, I get zero results, with it disabled, I can see the target approval record in the output of the results.
Does anyone have an idea why the 123TEXTQUERY321 field returns zero results for the table sysapproval_approver? When I navigate to the dictionary entries for sysapproval_approver, there is no related list entry to create a search index according to the Wiki article:
Administering Zing Text Search - ServiceNow Wiki
Testing the 123TEXTQUERY321 column in a background script
var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('state', 'requested');
gr.addQuery('sysapproval.sys_class_name','sc_req_item');
//gr.addQuery('123TEXTQUERY321', 'RITM0284161'); // enabling this returns zero results, event though the approval record for this approval exists
gr.query();
while(gr.next()){
gs.print(gr.sysapproval.number+', '+gr.sys_id+', '+gr.sysapproval.short_description)
}
