Knowledge table loads slow due to Stage column - Support and Troubleshooting

Knowledge table loads slow due to Stage column Issue The Knowledge table [kb_knowledge] loads slowly. When removing the stage column, the table loads quickly.

Cause There are a large number of table shards for the sys_audit table. When loading the knowledge table, we search all sys_audit tables for stage value changes for all articles displayed on the list.

Resolution In the 'WorkflowIcons' script include, we can replace:

var audited = this.getFieldValuesUsed(gr, fieldName);

with:

var audited = GlideAuditor.getFieldValuesUsed(gr, fieldName);