Skip to Content (Press Enter)
Back to Ideas
39
Like
Follow Idea
Accelerate the creation of basic Auditing fields
969Views
26Comments
New
AI/ML

When modeling the database or simply creating entities, it would be great if the platform suggested the creation of basic auditing fields, like CreatedOn, CreatedBy, UpdatedOn, UpdatedBy.

Of course it shouldn't mandatory, and the platform should be smart enough to understand when the entity is a good case for these types of fields. That's why I'm categorising it as in AI/ML.

Apart from that, it would be great if the platform set CurrDateTime() default value for CreatedOn.

Some sort of integration with another popular idea around custom wrapper actions would be appreciated too.

04 Jan 2021
Copy link to comment

Great idea, Perhaps it could be managed inside the aggregate editor for entities, maybe with the same interface logic as calculated attributes.

08 Jan 2021
Copy link to comment

Good idea. It is really very common to need to create these fields in some entities, and as one of the platform's ideas is to accelerate development, having this option would help.

11 Jan 2021
Copy link to comment
Merged this idea with 'Create/Modify date/time/user attribute automatically created when create a new entity' (created on 10 Feb 2021 09:39:29 by David Alves)
11 Feb 2021
Copy link to comment

The same way we have automatic attributes for static entities we should have those for dynamic entities.
90% of the case are needed



This comment was:
- originally posted on idea 'Create/Modify date/time/user attribute automatically created when create a new entity' (created on 10 Feb 2021 by David Alves)
- merged to idea 'Accelerate the creation of basic Auditing fields' on 11 Feb 2021 07:09:44 by Justin James
10 Feb 2021
Copy link to comment

Incredible idea! A true time-saver!



This comment was:
- originally posted on idea 'Create/Modify date/time/user attribute automatically created when create a new entity' (created on 10 Feb 2021 by David Alves)
- merged to idea 'Accelerate the creation of basic Auditing fields' on 11 Feb 2021 07:09:44 by Justin James
10 Feb 2021
Copy link to comment

It could be configured in the platform preferences if we would want to have this or not.

Would be great to have it and would save a lot of time



This comment was:
- originally posted on idea 'Create/Modify date/time/user attribute automatically created when create a new entity' (created on 10 Feb 2021 by David Alves)
- merged to idea 'Accelerate the creation of basic Auditing fields' on 11 Feb 2021 07:09:44 by Justin James
10 Feb 2021
Copy link to comment

great idea!



This comment was:
- originally posted on idea 'Create/Modify date/time/user attribute automatically created when create a new entity' (created on 10 Feb 2021 by David Alves)
- merged to idea 'Accelerate the creation of basic Auditing fields' on 11 Feb 2021 07:09:44 by Justin James
10 Feb 2021
Copy link to comment

It's missing the "IsActive" attribute. 

It should be always part of the entities by default.


25 Feb 2021
Copy link to comment
Merged this idea with 'Option to create Entities with GUID fields during Creation of new Entities' (created on 21 Jul 2021 07:10:33 by Sobi PILLAI)
22 Jul 2021
Copy link to comment

Problem: Quite often we need entities with GUID fields. This has to be manually handled by the developer and consumes dev time.

Solution: The idea is to give the developer an option during creation of entities to create entities with a GUID filed or without the GUID field 

Another possibility is to replace all identifiers with GUID values

 CRUD should take care of the GUID values generation for these entities.



This comment was:
- originally posted on idea 'Option to create Entities with GUID fields during Creation of new Entities' (created on 21 Jul 2021 by Sobi PILLAI)
- merged to idea 'Accelerate the creation of basic Auditing fields' on 22 Jul 2021 07:20:33 by Daniël Kuhlmann
21 Jul 2021
Copy link to comment
Merged this idea with 'Audit Fields during the creation of Entities' (created on 21 Jul 2021 06:54:45 by Sobi PILLAI)
24 Jul 2021
Copy link to comment

Currently when a new entity is created by default there is an identifier created and the CRUD actions are created


What would be nice is that we have an option to create new entities with audit fields (Created on /Created by Updated on/Updated by)

The CRUD actions should take care of the updates of these fields




This comment was:
- originally posted on idea 'Audit Fields during the creation of Entities' (created on 21 Jul 2021 by Sobi PILLAI)
- merged to idea 'Accelerate the creation of basic Auditing fields' on 24 Jul 2021 20:25:05 by Justin James
21 Jul 2021
Copy link to comment
Merged this idea with 'Entities - Audit Fields' (created on 01 Aug 2021 17:47:21 by Alexandrino Galveia)
02 Aug 2021
Copy link to comment

By default or at automatic demand create the audit fields in each entity:

  • IsActive (boolean)
  • CreatedBy (user identifier)
  • CreatedAt (date/time)
  • UpdatedBy (user identifier)
  • UpdatedAt (date/time)


This comment was:
- originally posted on idea 'Entities - Audit Fields' (created on 01 Aug 2021 by Alexandrino Galveia)
- merged to idea 'Accelerate the creation of basic Auditing fields' on 02 Aug 2021 06:57:24 by Daniël Kuhlmann
01 Aug 2021
Copy link to comment
Merged this idea with 'Automatic Generate the UpdatedOn And CreatedOn' (created on 04 Oct 2022 13:30:38 by Frederico Fernandes)
05 Oct 2022
Copy link to comment

Every time the Dev create a Entity the platform should create the attributes CreatedOn an UpdatedOn, also the it should handle that attributes, for example every time a record is changed the platform should change the UpdateOn this way the Dev doesn't need to assign in the code.


04 Oct 2022
Copy link to comment
20 Dec 2023
Copy link to comment
Merged this idea with 'Audit Attribute when creating new entity' (created on 22 Mar 2024 11:51:01 by Rohan Hanumante)
24 Mar 2024
Copy link to comment

Hi,

When we are creating the new normal entity OS by default ID attribute is created so likewise there should be Audit attribute like IsActive, CreatedOn, UpdatedOn created by OS platform.

Thanks

Rohan H

22 Mar 2024
Copy link to comment

Hi, please search first if the idea you want to post already existed. Double posted ideas will be merged.

24 Mar 2024
Copy link to comment
Merged this idea with 'Automated Inclusion of Common Audit Columns in OutSystems Entities' (created on 09 Jan 2025 12:08:57 by Neha Agrawal)
10 Jan 2025
Copy link to comment
2023-12-11 08-54-13
Neha Agrawal
Champion

Enhance the OutSystems platform to automatically include a set of predefined columns within every newly created entity:

  • IsActive: Boolean flag to indicate whether the record is active or inactive.
  • CreatedDate: Date/Time stamp of the record's creation.
  • CreatedBy: User identifier of the user who created the record.
  • UpdatedDate: Date/Time stamp of the last update to the record.
  • UpdatedBy: User identifier of the user who last updated the record.

These columns provide valuable audit information and enhance data integrity by enabling:

  • Soft deletes: Easily deactivate records without physically removing them.
  • Tracking record history: Monitor changes made to entities over time.
  • Improved data traceability: Identify the users responsible for creating and modifying data.

This feature would streamline the development process by eliminating the need to manually add these common columns to every entity, promoting consistent auditing practices across the application."

This enhancement would significantly improve development efficiency and data management capabilities within the OutSystems platform.

09 Jan 2025
Copy link to comment

This is really agood suggestion.

In my project I need to add CreatedBy,ModifiedBy,CreatedOn,ModifiedOn manually.

IsActive is needed some occasions.

But at the same time it should not be mandatory to add those.

So when Entity is created it should have 'right click' option to select one of above fields.


10 Jan 2025
Copy link to comment

Good idea, but exists already, so it will be merged.

10 Jan 2025
Copy link to comment
Merged this idea with 'Automatic Creation of Auditing Columns in OutSystems Entities' (created on 10 Jan 2025 10:20:24 by Neha Agrawal)
13 Jan 2025
Copy link to comment
2023-12-11 08-54-13
Neha Agrawal
Champion

Problem:

  • Creating and maintaining auditing columns (IsActive, CreatedDate, UpdatedDate, CreatedBy, UpdatedBy) in OutSystems entities is repetitive and time-consuming.
  • This manual process can lead to inconsistencies and errors in data tracking across different entities.

Solution:

  • Introduce a mechanism within the OutSystems platform to automatically create and manage essential auditing columns for newly created entities.
  • This functionality should mirror the automatic generation of the Id column, providing a streamlined and consistent approach to entity development.

Benefits:

  • Increased Efficiency: Significantly reduces development time by automating a common task.
  • Enhanced Consistency: Ensures all entities adhere to a standardized auditing framework.
  • Improved Data Quality: Minimizes the risk of errors and omissions in data tracking.
  • Simplified Maintenance: Streamlines future modifications and enhancements related to entity auditing.
10 Jan 2025
Copy link to comment