How to report on KB articles that are under "Published (In progress)" workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-12-2022 08:25 PM
I'm trying to create a report of all the KB articles that are currently waiting for Publishing Approval. I have tried using the approval table, but that does not contain the actual KB Workflow, but when using the kb_knowledge table, I am able to see the Workflow, but cannot specifically report on those KB articles with either "Published (Pending - has not started)" or "Published (In progress)".
Essentially, I would like to find a way to report on each of these workflow statuses as shown:
- Labels:
-
Knowledge Management
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2022 01:12 PM
Thank you, everyone, for the inputs and suggestion. I will try to use the report to filter out the workflow based on: Draft, Review, Scheduled for Publish and see. Basically, I want to make sure that there is a place where I can tell if some KB is stuck and waiting on someone to approve before it can be published. Knowledge is important and I do not want a miss in the process to deter users from not being able to self-help via KBs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2022 03:04 PM
I monitor articles in 'Review' for this reason and we have an email notification that goes out every Monday morning reminding people of anything pending their approval.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-15-2024 05:10 PM
Apologies for picking up on this subject/thread but just wanted to ask a question related to reporting. Management would like to create a report on KBAs waiting for approval. We have implemented a 3-layer approval workflow (1st-support, 2nd-owner, 3rd-SMEs). The report they would like to have is a list of all Knowledge Articles pending approval and to whom it is waiting approval from. I tried using the 'sysapproval_approver' table but its not something that I would like to share directly to the management. Is there an alternative way to accomplish this? Thanks!