How to create report on published knowledge articles without older versions

[SNhydrone]

Hi! Any insights on how to create a report on published knowledge articles without the older versions? When we do knowledge article reporting, there are duplicate records and it's probably versioning. But open to how others are doing this as I expect this to be a common report.

Thanks in advance!

[AndersBGS · Accepted solution]

Hi @SNhydrone ,

If you create a report based on kb_knowledge table with the conditions:

"latest is true" and "workflow is published", then you will get only the latest articles which are published.

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders 

[Nicolette]

Hi @AndersBGS , 

This was very helpful.  I'm trying to take it one step further and trying to remove any newly published articles from the above list (1.0) as I want to split newly created from existing updated and published. 

I was thinking of using the same filter but using the knowledge version related list conditions if I can get the ACLs to  work.  Do you have any other ways on how to achieve this?