Select the search type
  • Site
  • Web
Search
You are here:  Support/Forums
Support

Bring2mind Forums

DMX_Entries data question
Last Post 12/14/2009 12:20 PM by Peter Donker. 1 Replies.
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Laurence Neville
New Member
New Member
Posts:56


--
12/11/2009 3:27 PM

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

Peter Donker
Veteran Member
Veteran Member
Posts:4536


--
12/14/2009 12:20 PM
Hi Laurence,

All versions are grouped by LastVersionID

Created is when that specific version was uploaded.

LastModified is trigger whenever the record is touched (i.e. also when you edit metadata/attributes)

Understood about the difference between lastversioncreated and created. I'll make a note of this.

Peter
You are not authorized to post a reply.