Auto fillin attribute columns based using USERNAME

[woodbri]

It would be nice to be able to define attribute columns in the datastores of the config.xml that would be auto populated with the USERNAME from the session for create|update|delete events and possibly a timestamp column. These would be used for an audit history.

Delete is somewhat problematic, and we might want something like update the record with the delete fields, then delete it. The assumption here is that a trigger is archiving the records with each change so the delete info would not be lost.

So I might have hidden columns assocated with each record like:

createby

createdate

updateby

updatedate

deleteby

deletedate

and then each would get updated based on the appropriate transaction.

[adube]

I think this should be handled on the database integration directly. What do you think ?

[woodbri]

I think the issue here is that you need to tell the database what user is making the request. USERNAME is held in session It needs to be placed in an attribute column so when the request to update the database is made you have the USERNAME of the person making the request. It has been a while since I last used geoprisma, so maybe I'm forgetting how it all works. I'm not currently using geoprisma, so not needed by me.