I want to get the "Comment" for each Transition.
Please refer the below image,
Thanks in Advance.
Create an IEdmHistory object, add file(s), run GetHistory to get an array of EdmHistoryItem structs. Look for items with a type of Edmhist_FileState. The comment is stored in mbsComment.
In which table have the history of Edmhist_FileRevision. I want to combine the all three history tables FileVersion,FileSate and FileRevision to get the last modified date with comment for each document. I found the two tables names of FileVersion and FileSate.
We are talking about using the API, not querying the SQL database tables.
If you also want versions and revisions, add the Edmhist_FileVersion and Edmhist_FileRevision to Edmhist_FileState for the type criteria.
I found the table name(UserRev) where all FileRevision history is stored.
Using API's is best way to get those details but my requirements are some what complex so I am move to DB side to get the report.
Thanks a lot Micheal.
Retrieving data ...