Add built-in GUID function

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.

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

"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" ?

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

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.

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/