Add built-in GUID function

By Robert Chanphakeo on 12 Oct 2011
Add Built-in GUID function for GUID generation into Agile Platform, without needing to add an extension to auto generate GUID.
Kilian Hekhuis1 Nov 2011
If you use a SQL Server database, you can use the NEWID() function to generate a GUID. An advanced query is then all you need, no extension needed. On Oracle, it is called SYS_GUID(), if my Google-fu serves me well.
Goncalo Borrega15 May 2013
In version 8 this is a function available in the System actions
GUID function should be built into the agile platform.

In addition to this, there should be a "Is Auto GUID" option to allow an entity record to be created with an auto assigned GUID.



Merged from 'Entity: "Is AutoGUID" (built in GUID function)' (idea created on 2011-12-25 07:28:20 by Robert Chanphakeo), on 2013-05-15 11:21:34 by Gonçalo Borrêga
Just like you can select "CurrDateTime()" "CurrDate()"

There should be a built in function for "GetNewGuid()"

Merged from 'Entity: "Is AutoGUID" (built in GUID function)' (idea created on 2011-12-25 07:28:20 by Robert Chanphakeo), on 2013-05-15 11:21:34 by Gonçalo Borrêga
Kilian Hekhuis15 May 2013
"In version 8 this is a function available in the System actions" - Yeah, I noticed at NextStep, that's great.
Finally! outsystems 8.0 is doing what I want it to do :)
What about built in action for "GenerateGuidEntityId" ?

Kilian Hekhuis15 May 2013
A GUID is just a text string, so you could use TextToEntityRefText().
It would be good to have entity GUID datatype identifiers. so we dont have to assign GUID values manually


Kilian Hekhuis16 May 2013
Well, I don't have a use for that personally, but I can see someone else would. Perhaps Gonçalo didn't understand your request and merged it wrongly with this one.
Gonçalo
"In version 8 this is a function available in the System actions"

I mean add it as an entity "data type". We have text, integer, then we should have GUID for entities.
Goncalo Borrega27 Jan 2014
Hi guys,

I'm tracking the GUID datatype on this idea instead: Native support for UNIQUEIDENTIFIER data type

Left this one to be just for the builtin function (which already helps in some of the integration scenarios)
@Goncalo

GUID implementation method was added but currently there is still no native GUID data type support.

Why do we need it? see GUID discussion here http://www.outsystems.com/forums/discussion/13832/entity-with-guid-primary-key-identifier/