Forum OpenACS Development: Where to retrieve the modifying_user for acs_objects?

Collapse
1: Where to retrieve the modifying_user for acs_objects?
Posted by Torben Brosten on 06/30/06 08:13 AM
Has acs_objects.modifying_user information been moved to another table? If so, where?

Also, are we to assume that acs_objects.last_modified is the same as acs_objects.creation_date ?

If modifying_user and last_modified get updated on object_id modification, what call handles that?

Thanks in advance,

Torben

Collapse
2: Re: Res: Where to retrieve the modifying_user for acs_objects? (response to 1)
Posted by Jose Pablo Escobedo Del Cid on 06/30/06 10:56 AM
The call is done via the trigger 'acs_objects_last_mod_update_tr' (at least that's the name in postgres). The trigger is invoked every time the table 'acs_objects' is updated.

Also, some packages like file storage modifies these fields directly through a call to the 'acs_object__update_last_modified' plsql function (see 'file_storage__new_file' for example)

Finally, it depends on the application to call the function 'acs_object__new' with the information needed every time an object is created.

Regards,

jopez