2
 Followers
21
 Likes

Add built-in GUID function

Service Studio
Implemented
on 07 May 2013
OutSystems 8.0
Add Built-in GUID function for GUID generation into Agile Platform, without needing to add an extension to auto generate GUID.
Created on 12 Oct 2011
Comments (19)
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
Merged this idea with 'Entity: "Is AutoGUID" (built in GUID function)' (created on 2011-12-25 07:28:20 by - -)
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/
Merged this idea with 'Integration Studio GUID Conversion' (created on 21 Aug 2013 10:32:30 by Carlos Henriques)
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 http://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
views
1146
Followers
2