Forum OpenACS Development: join of acs_objects in content-repository x-views

Collapse
1: join of acs_objects in content-repository x-views
Posted by Timo Hentschel on 03/10/06 08:20 AM
Content-Repository creates the ${table_name}x view by (among other things) joining with acs_objects on revision_id. So, the creation_date of an entry of this view actually shows the revision date, not the item creation date. Is this really the desired behavior or do we want creation_date to be the item creation date?
Collapse
2: Re: join of acs_objects in content-repository x-views (response to 1)
Posted by Dave Bauer on 03/10/06 01:27 PM
Since it has been this way for years and years, and the view is called cr_revisionsx or ${cr_revision_subtype}x it makes sense for it to work that way.

The creation user etc refers to who created the revision in question as well.

Also I would hesitate to change behavior arbitrarily since it has worked this way for so long.

Collapse
3: Re: join of acs_objects in content-repository x-views (response to 1)
Posted by Malte Sussdorff on 03/10/06 02:14 PM
Maybe we should not change it but take this into account for the next generation of the view. Maybe add an item_creation_date to it.

Furthermore, I stumbled upon the fact that a new revision of an item does not trigger an update on the last_modified date of the acs_object associated with the item.

For us the publish_date of the revision is what counts anyway (with regards to project-manager and contacts), so we are fine here, but it might make sense to keep this discrepancy in mind as well or at least educate people about it.