I wonder if there is a way to take advantage of the binary datatype to manipulate json in Semarchy ? Or maybe work with native functions and specific form field display/rules to seamlessly convert string to json and vice versa ?
I could also ask : is "JSON datatype" in the roadmap ?
Best Answer
C
Cédric BLANC
said
over 2 years ago
There is currently no JSON datatype in the xDM roadmap.
You can use the LongText datatype to store JSON content in attributes, but there is no specific feature to manipulate data stored in JSON format. The risk with storing JSON would be either to store data on which designers have no control (format, constraints...), or to have a "datamodel in the datamodel", which would add complexity for both designers and end-users.
1 Comment
Cédric BLANC
said
over 2 years ago
Answer
There is currently no JSON datatype in the xDM roadmap.
You can use the LongText datatype to store JSON content in attributes, but there is no specific feature to manipulate data stored in JSON format. The risk with storing JSON would be either to store data on which designers have no control (format, constraints...), or to have a "datamodel in the datamodel", which would add complexity for both designers and end-users.
Cédric BLANC
Is there a way to store and edit (with a user friendly experience) a JSON content within a Semarchy attribute ?
In Postgresql for instance we have a datatype "jsonb" (for json binary) which is very handful to manipulate nested data (https://www.cloudbees.com/blog/unleash-the-power-of-storing-json-in-postgres)
I wonder if there is a way to take advantage of the binary datatype to manipulate json in Semarchy ? Or maybe work with native functions and specific form field display/rules to seamlessly convert string to json and vice versa ?
I could also ask : is "JSON datatype" in the roadmap ?
There is currently no JSON datatype in the xDM roadmap.
You can use the LongText datatype to store JSON content in attributes, but there is no specific feature to manipulate data stored in JSON format. The risk with storing JSON would be either to store data on which designers have no control (format, constraints...), or to have a "datamodel in the datamodel", which would add complexity for both designers and end-users.
Cédric BLANC
There is currently no JSON datatype in the xDM roadmap.
You can use the LongText datatype to store JSON content in attributes, but there is no specific feature to manipulate data stored in JSON format. The risk with storing JSON would be either to store data on which designers have no control (format, constraints...), or to have a "datamodel in the datamodel", which would add complexity for both designers and end-users.
-
Extend a model with new entities or attributes
-
Data types in xDM
-
Effective date on entities
-
Search using wild cards
-
Export a model from production and import on a development environment
-
"Allow Delete" vs "Allow Removal" privileges
-
LOV label in Named Query
-
Select location on a map and save coordinates
-
Is there a way to set up a master-detail relationship on browse mode?
-
Choose Either a Stepper or A Workflow Based on The User Privileges
See all 275 topics