Knowledge reporting

Jon Miller1 · ‎02-16-2023

I've created a simple report to show my knowledge articles at their different states. The purpose is to identify articles that I've submitted but that haven't been approved yet and to show when my articles have become outdated and I need to update them. I'm reporting on the Knowledge [kb_knowledge] table with a filter Author is (dynamic) Me and Latest = true. See the attached for the resulting pie-chart.

As you can see it shows 10 articles in the Review state. But if I click on that section, it only show one article in the resulting list. I think the 1 is correct but what are the other 9, why do they show up in the report and why can I not see them in the list? I had our admin try and he sees the same result.

AshishKM · ‎02-17-2023

The core logic written in the script include : KBKnowledgeSNC

read the canRead() method from this code.

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

Jon Miller1 · ‎02-17-2023

It's a good place to start, Ashish, but even that has too much embedded scripting for me to work through. It doesn't look like there is an easy answer so will just have to live with it for now.

AshishKM · ‎02-17-2023

Hi,

You can try the same ACL without the script code in your PDI. Remove it [ Keep the source code ] and then try it. Let's see the results.

Do you have admin role or itil role on your PROD system ?

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

ernestomora · ‎08-28-2024

Hello everyone,

I need some guidance with Knowledge reporting as well, I'm trying to create a report that shows a count on Articles published AND articles updated, so basically new ones and modified ones, but only performed by my team members, the last part is not an issue, but the initial report is where I'm lost, I'll greatly appreciate your assistance.