Sign up
Log in
My Platform
Tools
Tools
Go back
Downloads
IPP
Licensing
Learn
Learn
Go back
Training
Welcome
Guided Paths
Training Planner
Courses
Tech Talks
Classroom
Certifications
Documentation
Overview
OutSystems 11
Best Practices
How-to Guides
Community
Community
Go back
Home
Jobs
Forums
Forge
Ideas
Members
Badges
Support
OutSystems.com
Sign up
Log in
Community
›
Ideas
›
Add built-in GUID function
Advanced Search
2
Followers
21
Likes
Add built-in GUID function
- -
- -
at
+ 2
#30
in Community Rank
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
)
Kilian Hekhuis
1 Nov 2011
Kilian Hekhuis
MVP
Functional Specialist
at
MAIN Energie
+ 12
#2
in Community Rank
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.
Gonçalo Borrêga
15 May 2013
Gonçalo Borrêga
Sr. Director, Product Management
at
OutSystems
+ 3
#0
in Community Rank
In version 8 this is a function available in the System actions
Gonçalo Borrêga
15 May 2013
Gonçalo Borrêga
Sr. Director, Product Management
at
OutSystems
+ 3
#0
in Community Rank
Merged this idea with
'Entity: "Is AutoGUID" (built in GUID function)' (created on 2011-12-25 07:28:20 by - -)
- -
25 Dec 2011
- -
at
+ 2
#30
in Community Rank
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
- -
4 Jan 2012
- -
at
+ 2
#30
in Community Rank
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 Hekhuis
15 May 2013
Kilian Hekhuis
MVP
Functional Specialist
at
MAIN Energie
+ 12
#2
in Community Rank
"In version 8 this is a function available in the System actions" - Yeah, I noticed at NextStep, that's great.
- -
15 May 2013
- -
at
+ 2
#30
in Community Rank
Finally! outsystems 8.0 is doing what I want it to do :)
- -
15 May 2013
- -
at
+ 2
#30
in Community Rank
What about built in action for "GenerateGuidEntityId" ?
Kilian Hekhuis
15 May 2013
Kilian Hekhuis
MVP
Functional Specialist
at
MAIN Energie
+ 12
#2
in Community Rank
A GUID is just a text string, so you could use TextToEntityRefText().
- -
15 May 2013
- -
at
+ 2
#30
in Community Rank
It would be good to have entity GUID datatype identifiers. so we dont have to assign GUID values manually
Kilian Hekhuis
16 May 2013
Kilian Hekhuis
MVP
Functional Specialist
at
MAIN Energie
+ 12
#2
in Community Rank
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.
- -
27 Jan 2014
- -
at
+ 2
#30
in Community Rank
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.
Gonçalo Borrêga
27 Jan 2014
Gonçalo Borrêga
Sr. Director, Product Management
at
OutSystems
+ 3
#0
in Community Rank
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)
- -
26 Feb 2015
- -
at
+ 2
#30
in Community Rank
@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/
Hugo Gonçalves
18 Jul 2018
Hugo Gonçalves
Product Manager
at
OutSystems
#729
in Community Rank
Merged this idea with
'Integration Studio GUID Conversion' (created on 21 Aug 2013 10:32:30 by Carlos Henriques)
Carlos Henriques
21 Aug 2013
Carlos Henriques
Manager
at
Becker Professional Education
+ 5
#90
in Community Rank
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
J.
3 Sep 2013
J.
MVP
Outsystem MVP, Outsystems Expert developer, Senior consultant
at
CoolProfs
+ 14
#14
in Community Rank
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
- -
22 Sep 2013
- -
at
+ 2
#30
in Community Rank
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
- -
26 Feb 2015
- -
at
+ 2
#30
in Community Rank
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
views
3173
Followers
2
Loading...
Loading
(hidden) New Badge Popup