We are trying to build a query to show details on Complex Type. So far we have managed to identify the entities mta_cplxtype and mta_attribute and mta_enr_output. However there seems to be a need for one more entity to link the first 2 entities to the 3rd one. So far we have been unable to identify this one.
We would appreciate your help in this entity.
I would also be interested if there is a list available with all the entities used and there purpose decription?
Ed
Best Answer
A
Alexia SIMOND
said
over 1 year ago
Hello Ed,
I need to preface by saying that, as mentioned in our documentation, "although the repository is stored in a database schema, it should never be accessed directly via SQL queries. Access to the Semarchy xDM information must be performed through the Semarchy user interfaces."
Hence why there is no documentation for general consumption.
That being said, I will try to help you as best as possible to achieve your requirement.
And to that extent, I think I'm missing something to fully understand the context.
Why is the mta_enr_output involved in the mix if you want details on complex type?
The only reason that I can see, would be if you want to find information on attributes of complex types enriched.
And for that, I would do something along those lines. This is only an example for v0.1 of the demo CustomerB2C:
select *
from mta_attribute a
join mta_enr_expr ee on (substr(attr_name, 1, case when position('.' in ee.attr_name) > 0 then position('.' in ee.attr_name)-1 else 0 end)) = a.name and a.editionid = ee.editionid and a.branchid = ee.branchid
join mta_cplxtype ct on a.r_cplxtype = ct.uuid and a.editionid = ct.editionid and a.branchid = ct.branchid
join mta_entity e on a.o_entity = e.uuid and a.editionid = e.editionid and a.branchid = e.branchid
join mta_root_model m on e.o_model = m.uuid
where m.name = 'CustomerB2CDemo'
and a.branchid = 0
and a.editionid = 1;
Please note to adjust this according to your own context.
Hope that helps
1 Comment
A
Alexia SIMOND
said
over 1 year ago
Answer
Hello Ed,
I need to preface by saying that, as mentioned in our documentation, "although the repository is stored in a database schema, it should never be accessed directly via SQL queries. Access to the Semarchy xDM information must be performed through the Semarchy user interfaces."
Hence why there is no documentation for general consumption.
That being said, I will try to help you as best as possible to achieve your requirement.
And to that extent, I think I'm missing something to fully understand the context.
Why is the mta_enr_output involved in the mix if you want details on complex type?
The only reason that I can see, would be if you want to find information on attributes of complex types enriched.
And for that, I would do something along those lines. This is only an example for v0.1 of the demo CustomerB2C:
select *
from mta_attribute a
join mta_enr_expr ee on (substr(attr_name, 1, case when position('.' in ee.attr_name) > 0 then position('.' in ee.attr_name)-1 else 0 end)) = a.name and a.editionid = ee.editionid and a.branchid = ee.branchid
join mta_cplxtype ct on a.r_cplxtype = ct.uuid and a.editionid = ct.editionid and a.branchid = ct.branchid
join mta_entity e on a.o_entity = e.uuid and a.editionid = e.editionid and a.branchid = e.branchid
join mta_root_model m on e.o_model = m.uuid
where m.name = 'CustomerB2CDemo'
and a.branchid = 0
and a.editionid = 1;
Please note to adjust this according to your own context.
Ed THEEBOOM
Hi All,
We are trying to build a query to show details on Complex Type. So far we have managed to identify the entities mta_cplxtype and mta_attribute and mta_enr_output. However there seems to be a need for one more entity to link the first 2 entities to the 3rd one. So far we have been unable to identify this one.
We would appreciate your help in this entity.
I would also be interested if there is a list available with all the entities used and there purpose decription?
Ed
Hello Ed,
I need to preface by saying that, as mentioned in our documentation, "although the repository is stored in a database schema, it should never be accessed directly via SQL queries. Access to the Semarchy xDM information must be performed through the Semarchy user interfaces."
Hence why there is no documentation for general consumption.
That being said, I will try to help you as best as possible to achieve your requirement.
And to that extent, I think I'm missing something to fully understand the context.
Why is the mta_enr_output involved in the mix if you want details on complex type?
The only reason that I can see, would be if you want to find information on attributes of complex types enriched.
And for that, I would do something along those lines. This is only an example for v0.1 of the demo CustomerB2C:
select *
from mta_attribute a
join mta_enr_expr ee on (substr(attr_name, 1, case when position('.' in ee.attr_name) > 0 then position('.' in ee.attr_name)-1 else 0 end)) = a.name and a.editionid = ee.editionid and a.branchid = ee.branchid
join mta_cplxtype ct on a.r_cplxtype = ct.uuid and a.editionid = ct.editionid and a.branchid = ct.branchid
join mta_entity e on a.o_entity = e.uuid and a.editionid = e.editionid and a.branchid = e.branchid
join mta_root_model m on e.o_model = m.uuid
where m.name = 'CustomerB2CDemo'
and a.branchid = 0
and a.editionid = 1;
Please note to adjust this according to your own context.
Hope that helps
Alexia SIMOND
Hello Ed,
I need to preface by saying that, as mentioned in our documentation, "although the repository is stored in a database schema, it should never be accessed directly via SQL queries. Access to the Semarchy xDM information must be performed through the Semarchy user interfaces."
Hence why there is no documentation for general consumption.
That being said, I will try to help you as best as possible to achieve your requirement.
And to that extent, I think I'm missing something to fully understand the context.
Why is the mta_enr_output involved in the mix if you want details on complex type?
The only reason that I can see, would be if you want to find information on attributes of complex types enriched.
And for that, I would do something along those lines. This is only an example for v0.1 of the demo CustomerB2C:
select *
from mta_attribute a
join mta_enr_expr ee on (substr(attr_name, 1, case when position('.' in ee.attr_name) > 0 then position('.' in ee.attr_name)-1 else 0 end)) = a.name and a.editionid = ee.editionid and a.branchid = ee.branchid
join mta_cplxtype ct on a.r_cplxtype = ct.uuid and a.editionid = ct.editionid and a.branchid = ct.branchid
join mta_entity e on a.o_entity = e.uuid and a.editionid = e.editionid and a.branchid = e.branchid
join mta_root_model m on e.o_model = m.uuid
where m.name = 'CustomerB2CDemo'
and a.branchid = 0
and a.editionid = 1;
Please note to adjust this according to your own context.
Hope that helps
-
Deployment History Date
-
Username in Tomcat Access Logs
-
Is It Possible to Perform Automatic Authentication with The User's Windows Account?
-
Where is the documentation for Version 5.2.5?
-
On Prem Semarchy Authentication using Azure AD?
-
Delete old models
-
Sync production model version with dev
-
Recreate a dev environment. Any side effect?
-
Indexes on xDM database tables
-
What logging technology is used in the Semarchy xDM platform?
See all 82 topics