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."
> https://www.semarchy.com/doc/semarchy-xdm/xdm/latest/Admin/overview.html#_repository_contents
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
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