Open zoometh opened 1 year ago
Thesauri : Bronze Age (Arabia) (en-US) (Concept) -> https://database.eamena.org/concepts/4550d0f3-24c2-4ada-9fbe-52e5974db973
https://database.eamena.org/concepts/4550d0f3-24c2-4ada-9fbe-52e5974db973
https://database.eamena.org/concepts/4a98075d-815f-327b-be0e-518b32f7623b
Concepts : Bronze Age (Arabia) (en-US) (Concept) -> 4550d0f3-24c2-4ada-9fbe-52e5974db973
4550d0f3-24c2-4ada-9fbe-52e5974db973
2207326d-e72a-48f7-ae7b-6f223d555a7a
In both cases the UUID is 4550d0f3-24c2-4ada-9fbe-52e5974db973
On the table concepts
concepts
select * from concepts where legacyoid like 'https://database.eamena.org/concepts/4550d0f3-24c2-4ada-9fbe-52e5974db973'
Will give:
"4550d0f3-24c2-4ada-9fbe-52e5974db973" "https://database.eamena.org/concepts/4550d0f3-24c2-4ada-9fbe-52e5974db973" "Concept"
On the table nodes, filtering on Cultural Period (en-US) (Collection) -> 2207326d-e72a-48f7-ae7b-6f223d555a7a
nodes
select name, datatype, fieldname, alias from nodes where config ->> 'rdmCollection' LIKE '2207326d-e72a-48f7-ae7b-6f223d555a7a'
"Cultural Period" "concept" "cultural_period" "Cultural Period Type" "concept" "Period" "cultural_period_type"
Insert new values in the table nodes (sql_command) using INSERT
Description
In the RDM:
Thesauri : Bronze Age (Arabia) (en-US) (Concept) ->
https://database.eamena.org/concepts/4550d0f3-24c2-4ada-9fbe-52e5974db973
https://database.eamena.org/concepts/4a98075d-815f-327b-be0e-518b32f7623b
Concepts : Bronze Age (Arabia) (en-US) (Concept) ->
4550d0f3-24c2-4ada-9fbe-52e5974db973
2207326d-e72a-48f7-ae7b-6f223d555a7a
In both cases the UUID is
4550d0f3-24c2-4ada-9fbe-52e5974db973
In Postgres:
On the table
concepts
Will give:
On the table
nodes
, filtering on Cultural Period (en-US) (Collection) ->2207326d-e72a-48f7-ae7b-6f223d555a7a
Will give:
Solution
Insert new values in the table
nodes
(sql_command) using INSERT