Filter our Knowledge Base articles to only most recent version

[rajasekharteja]

Super simple one (I hope). 

I'm trying to build a modules to show all our KB articles one module for published and one for not published. But the "versions" is creating a lot of clutter. I just want to see the most recent version of every article (published or not published). 

Example - if I have an article that has been renewed/published 3 times. So version 1 is expired, version 2 is expired, but version 3 is in Draft. I want to see version 3 as the draft, but not version 1 or version 2.  

And in the same example view, I want to also see all other "most recent version" of any article. So If I have 10 articles, and 6 are published and 4 are draft, 6 should be shown under Published module and 4 should be shown under not published module.

I can't seem to figure this one out....

[Mark Manders]

That can't be done as a simple report. The 'version' is a reference to the kb_version table. One thing you could do if this report is of high value for some one, is to create a new field on the kb_knowledge form like 'u_latest_version' and have logic update it. As soon as a new version record is created, you set that version to 'latest version' and untick it on the previous one. OOB it just won't let you. Mainly normally 'Draft' would be the latest version and if no 'draft', 'Published' and if no 'draft' and no 'published' it would be 'Retired'. What would the added value of this report be?

[rajasekharteja]

Hi Mark,

Apologies for the confusion, it's not the report it is separate modules I need to show for Published and Not published articles only with the most recent version of every article.

Thanks, 

[Mark Manders]

That's even more confusing: there can be only one most recent version on 'published' articles and that's the published one. 

[AndersBGS]

Hi @rajasekharteja ,

If you look in the table kb_knowledge, you will have the ability yo utilize the columns: latest, published and workflow which should give you what you're looking for.

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

Best regards

Anders

[AndersBGS]

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

Best regards

Anders