Skip to Content (Press Enter)
Back to Ideas
21
Like
Follow Idea
Add built-in GUID function
5406Views
19Comments
Implemented
Service Studio
OutSystems 8.0
Add Built-in GUID function for GUID generation into Agile Platform, without needing to add an extension to auto generate GUID.
12 Oct 2011
Copy link to comment
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.
01 Nov 2011
Copy link to comment
2016-11-21 23-23-05
Gonçalo Borrêga
In version 8 this is a function available in the System actions
15 May 2013
Copy link to comment
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
25 Dec 2011
Copy link to comment
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
04 Jan 2012
Copy link to comment
"In version 8 this is a function available in the System actions" - Yeah, I noticed at NextStep, that's great.
15 May 2013
Copy link to comment
Finally! outsystems 8.0 is doing what I want it to do :)
15 May 2013
Copy link to comment
What about built in action for "GenerateGuidEntityId" ?

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


15 May 2013
Copy link to comment
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.
16 May 2013
Copy link to comment
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.
27 Jan 2014
Copy link to comment
2016-11-21 23-23-05
Gonçalo Borrêga
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)
27 Jan 2014
Copy link to comment
@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/
26 Feb 2015
Copy link to comment
2016-11-21 23-23-05
Gonçalo Borrêga
Merged this idea with 'Entity: "Is AutoGUID" (built in GUID function)' (created on 2011-12-25 07:28:20 by - -)
15 May 2013
Copy link to comment
Merged this idea with 'Integration Studio GUID Conversion' (created on 21 Aug 2013 10:32:30 by Carlos Henriques)
18 Jul 2018
Copy link to comment
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
21 Aug 2013
Copy link to comment
2016-04-21 20-09-55
J.
 
MVP
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
03 Sep 2013
Copy link to comment
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
22 Sep 2013
Copy link to comment
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
26 Feb 2015
Copy link to comment