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

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
Posted by Dave Bauer on
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.

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.