[daisy] Query lastModified

[Bruno Dumon]

On Tue, 2008-03-04 at 16:40 +0100, Karel Vervaeke wrote:
> I think (but would need to check to be sure) that changing
> none-versioned properties (such as the private and retired flag) would
> change the lastModified fields, but not the versionCreation fields.
> 

Indeed, though it's worth mentioning the *variant*LastModified/Modifier.

It's best to have a look at the document structure diagram:

http://cocoondev.org/daisydocs-2_2/34-cd/version/default/part/ImageData/data/daisy_document_structure.png

lastModified and lastModifier are updated when any of the document-level
properties change, this is only:  the owner, the private flag, the
reference language (Daisy 2.2).

variantLastModified and variantLastModifier are updated when any of the
non-versioned variant-level properties change, and also when a new
version is created. Hence, from the moment anything changes which is not
the earlier mentioned document-level properties.

versionLastModified and versionLastModifier are updated when any of the
version metadata is updated (the actual version content -- parts,
fields, ... -- is read-only after version creation). In this case,
variantLastModified and variantLastModifier are not updated.

> Also, when search_last_version=false (which is the default), the
> versionId is equal to the published version - this is not necessarily
> the same as the last version.
> 
> In short, the intent of lastModified and lastModifier is implied by the
> name, but one needs to keep in mind what exactly counts as a
> modification.
> 
> Regards,
> Karel
> 
> On Tue, 2008-03-04 at 08:50 -0600, Parisi, Lou wrote:
> > I had a query using the fields lastModified and lastModifier.  I found
> > that this actually corresponded to the creator and creation time.  I
> > just wanted to see if someone could clarify the intent.  This is the
> > query:More or less
> > 
> > select name, versionId, versionCreatorName, versionCreationTime,
> > lastModified, lastModifierName where ....
> > 
> > * versionId returns the latest version number
> > 
> > * versionCreatorName and versionCreationTime return the respective name
> > and time for the last version
> > 
> > * lastModified and lastModifierName seem to return the document creation
> > date and owner or creator.
> > 
> > What is the intent of lastModified and lastModifierName?
> > 
> > Thanks, Lou Parisi

-- 
Bruno Dumon                             http://outerthought.org/
Outerthought                            http://www.daisycms.org/
bruno at outerthought.org              http://www.kauriproject.org/