Hi wonderful knowledge managers,
I am trying to find only knowledge articles that have had their first version published during the last month, and which are still published and past their valid to date. We have versioning turned on. There doesn’t seem to be any field in the knowledge table that represents the date this knowledge article’s first version was published.
This is what I've got so far:
Table: kb_knowledge
Published on Last Month AND
Workflow is Published AND
Valid to at or after Today AND
Version.Version is 1.0
The problem with this query is that some knowledge articles were published for the first time during the last month, but have now had more recent versions published. These articles would have a version later than 1.0.
I know I can change the condition to workflow is Published OR Outdated, but that will bring me the outdated versions of the articles in my results. What I really want is the record for Published version 2.0, 3.0 or whatever, if the outdated version 1.0 of the same article was first published during the last month.
I thought the "Base Version" reference might be the first original version of the knowledge article but just seems to be the previous version, which doesn’t really help me either.
Does anyone have an idea of how to build this query?
Kind Regards and Thanks,
Janelle
