Super simple one (I hope).
I'm trying to build a report to see all our KB articles. 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, no matter how many previous versions exist for each, I just want to see the total 10 articles.
I can't seem to figure this one out....
