AnsweredAssumed Answered

Query document history?

Question asked by Jonathan Poole on Jan 31, 2021
Latest reply on Feb 1, 2021 by Jonathan Poole

I'm looking for a SQL query to get ALL of the data that appears in a documents history (right-click on a file, select History).

 

I found a query in the forums from 2 years ago - File history - in SQL  - but this does not return all of the data that is displayed in the history dialog box. It has the workflow transitions but not a record of when the document was created, or each time it was is checked in, etc.

 

I think that data from the Revisions table needs to be combined with data from the TransitionHistory table but I'm not sure of how to do that.

 

Thanks.

Outcomes