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 https://www.outsystems.com/forums/discussion/13832/entity-with-guid-primary-key-identifier/

When importing entities from SQL Server database with Integration Studio, it leaves the data type empty for GUID columns because Outsystems does not support this type.
Instead of leaving it blank, why not at least assume the text or entity reference text types?


Merged from 'Integration Studio GUID Conversion' (idea created on 21 Aug 2013 10:32:30 by Carlos Henriques), on 18 Jul 2018 17:11:57 by Hugo Gonçalves

Or have GUID as a outsystems type (which has been proposed before)



Merged from 'Integration Studio GUID Conversion' (idea created on 21 Aug 2013 10:32:30 by Carlos Henriques), on 18 Jul 2018 17:11:57 by Hugo Gonçalves

Correct behaviour would be to detect column is a GUID datatype, and set it to outsystems datatype "text".




Merged from 'Integration Studio GUID Conversion' (idea created on 21 Aug 2013 10:32:30 by Carlos Henriques), on 18 Jul 2018 17:11:57 by Hugo Gonçalves

this idea is related to https://www.outsystems.com/ideas/936/add-built-in-guid-function

Merged from 'Integration Studio GUID Conversion' (idea created on 21 Aug 2013 10:32:30 by Carlos Henriques), on 18 Jul 2018 17:11:57 by Hugo Gonçalves