6
 Followers
28
 Likes

Add a GUID data type support to OutSystems Platform

Other
New

With the introduction of the Dynamic Case Management Framework, OutSystems advocates to use GUID as a unique Text Identifier (see https://success.outsystems.com/Documentation/Case_Management/Create_a_case_management_app).

Apart from that GUID as identifiers have some other use cases too:

  • Less "hackable" URLs to your application pages than when using Integer Identifiers
  • Less meaningful Identifiers (Employee number 2 is probably longer with the company than Employee number 58)
  • You want the data to be uniquely-identified, no matter where it came from.
  • You need to be able to combine data from difference sources with little-to-no chance of duplicate GUIDs.
  • Furthermore, you don't want or don't care about the users needing to remember an ID themselves

It would be nice if there is more support in the Platform:

  • Add a new datatype called GUID, with an AutoNumber option.

  • Add a popup menu option to generate a GUID and set it as a string literal for any attribute of datatype GUID

  • Add built-in feature to also generate a GUID for Mobile and Reactive, as it is currently only available server side. Yes Forge component exists to help you, but this should be build in.
Created on 24 Mar
Comments (9)
Merged this idea with 'Identifier Column Text with GenerateGuid() Default' (created on 26 Sep 2020 14:07:16 by Giovane)

Sometimes, for security, we make a column with text datatype for primary key. Is be nice could have the GenerateGuid() as Default option to populate this column, instead of make this in Server Action customized.



This comment was:
- originally posted on idea 'Identifier Column Text with GenerateGuid() Default' (created on 26 Sep 2020 by Giovane)
- merged to idea 'Add a GUID data type support to OutSystems Platform' on 31 Mar 2021 06:38:06 by J.

Good idea.



This comment was:
- originally posted on idea 'Identifier Column Text with GenerateGuid() Default' (created on 26 Sep 2020 by Giovane)
- merged to idea 'Add a GUID data type support to OutSystems Platform' on 31 Mar 2021 06:38:06 by J.

I am amazed this is not already an idea from way back..


Hi Joost, Justin James already pointed to this old idea, that I missed when searching, before I created mine.

https://www.outsystems.com/ideas/935/auto-guid-for-entity-primary-key-id

But I would not like to get mine merged into it as I propose more than just a GUID identifier.

Good idea!

Furthermore, a GUID consists of 16 bytes which is more efficient than generating a GUID as a string, which needs 36 characters (including hyphens).

Along with GUID, a Ticks data type could also be available.

I would suggest UUIDnumber for which the indexes are smaller, but I am also fine with the standard UUID. And of course it should be an option to have this value to be automatically entered.

This is a very good idea! Some projects I needed the primary key to be the GUID, mainly for integration use with external systems. With this feature, it would further optimize development time and improve information security.

views
411
Followers
6