Facet filter field name

[Danny Roso]

Hi everyone,

When changing a field name that is in use as a Facet field, the change is not displayed afterwards in the Facet filter in Service Portal. For example after changing the title of a Knowledge Base, the new title is not shown in the Facet filter kb_knowledge.kb_knowledge_base. Tested on a lower Tokyo instance and noticed after a full index of the indexed source Knowledge Table the changed title did appear in the facet filter.

Is it really necessary to perform a full index in this case or is there something else that can be done?

[Amit Gujarathi]

HI @Danny Roso ,
I trust you are doing great.

Performing a full index of the indexed source Knowledge Table, as you mentioned in your case, can indeed resolve this issue. However, there might be an alternative solution that you can try before resorting to a full index.

You can try clearing the facet cache, which can sometimes help in refreshing the Facet filter. To do this, you can use the following script:

// Clear the facet cache
var gr = new GlideRecord('sys_ui_facet');
gr.addQuery('table', 'kb_knowledge');
gr.addQuery('field', 'kb_knowledge_base');
gr.query();
while (gr.next()) {
  gr.deleteRecord();
}

[Danny Roso]

Hi @Amit Gujarathi

Thank you for your response! Interesting to find there is another approach.

I would like to try this, however I don't find a table 'sys_ui_facet'. 

It would be nice if it is dynamically updated, so I also created an enhancement request in the Idea portal for this.

Best regards