Can entity Updated_by field be included when item created

[david.jones]

Hi

When a new entity is created the created_by, create_ts and update_ts fields are included in the db for the newly created item. Is there a way to also include the updated_by?

Having the updated_by field also included when an item is created means that we only need to display updated_ts and updated_by fields in gui tables (to show the audit trails). Without the updated_by included it means that we have to include 4 columns in tables (created_ts, created_by, updated_ts & updated_by) for the audit trail which is unnecessary when all the user really wants to know is who last updated the entity regardless of if it was a created or updated item.

Thanks

[mbucan (Mladen Bucan)]

Hello,

what you are saying is logical in the context of your use case, however, many people would say they like the way it is because they have information if a record has been changed at all after its creation.
Some people are also unhappy because they need more detailed audits…

In your case, there are several solutions:

• use AfterCommitChangesEvent , and if changed_by field is empty set it with value from created_by
  Screen Events - CUBA Platform. Developer’s Manual
  Downside is you need to do it for every entity you wish to behave like this.
• people used to do it with database triggers
• find the CUBA code that does this, and override it so it behaves like you want
• write a loader to get the created_by value if changed_by is empty
  Data Loaders - CUBA Platform. Developer’s Manual
• or do something like that on the display, if you are using a DataGrid you can add generated column that shows the appropriate value
  DataGrid - CUBA Platform. Developer’s Manual

Kind regards,
Mladen