Knowledge reporting

[Jon Miller1]

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]

Hi Jon,

Please check those 9 record, they must be in other state like [ Draft or Published ].

Latest = true, will give all KB either in published state or draft.

Try with state = review, and remove the Latest condition. Check the count again

[Jon Miller1]

Thanks Ashish but that's not it. The report is of all Knowledge where Latest = true, regardless of state. The report shows me 10 Knowledge records at a state of Review but if I drill-down, only 1 record is listed. The report also shows 197 records Published (but only 28 listed) and 13 Retired (but only 2 listed). My theory is that an ACL is allowing the records to be reported but not to be read. I've taken a look in my PDI and there is complex scripting for the "read" ACL. I was hoping somebody in this group could turn that into plain English for me. What prevents individual Knowledge records from being listed?

[AshishKM]

Hi,

Checked this read ACL on kb_knowledge table with public role. The ACL script is checking the condition for some legacy record setting which can be read from script include : KBKnowledgeSNC

Seems like , with you role this script is always returning the false.

Let me know if this the same script which you are referring there.

[Jon Miller1]

That's the script I was looking at, Ashish. But it's not always returning false. I see 1 of the Review records where I am the Author and but not the other 9. I suspect the 9 are older versions, maybe (like you say) from legacy records (we started on Geneva and are now on San Diego). But I'd like to understand the condition that's filtering them out so that I can apply the same condition to my report. I can continue to dig through the script but I thought somebody smarter than me in this group would have an easy answer.