Each version of a document seems to be stored in DMX_Entries as a separate record. What is the key column that is used to group all versions of a single document. Is it OriginalFileName?
Separate question:
In the attributes system, the "created" attribute is defined in the manual as "Date when entry was first created". Does this equate to min(Created) grouping by the document identifier above?
Also, "lastmodified" is defined as "Date when entry was last edited". Does this equate to max(LastModified) grouping by the document identifier above?
If so, I have a feature request:
Create a new attribute called "lastversioncreated", defined as max(Created) grouping by the document identifier. This would capture the last date when a new version of the file was uploaded. In my experience, users want to know when the file itself was last changed. Last Modified captures the last time the other properties of the document were altered, which might be irrelevant to most users.
Thanks