I was running a query to retrieve entity list from a ER diagram (display area) under a subject area. As per my knowledge the hierarchy is Model has many subject areas and each subject area has many ER Diagrams . I tried the below query to list super types for a ER Diagram under a subject area
tran (LEnP.Name) 'Parent Entity Name',
tran (LEnP.User_Formatted_Physical_Name) 'Parent Table Name',
tran (LEnC.Name) 'Child Entity Name',
tran (LEnC.User_Formatted_Physical_Name) 'Child Table Name',
tran (LRel.Type) 'Relationship Type'
INNER JOIN Entity LEnP
ON LRel.Parent_Entity_Ref = LEnP.Id@
INNER JOIN Entity LEnC
ON LRel.Child_Entity_Ref = LEnC.Id@
INNER JOIN M0.USER_ATTACHED_OBJECTS_REF saf
INNER JOIN M0.Subject_Area s
INNER JOIN ER_DIAGRAM ed
where tran(LRel.TYPE) = 'Subtype' and s.name ='Visualization' and ed.name='ER_Diagram_14818'
ORDER BY 1,3
It shows list of subtypes even if no entity is populated in ER_Diagram_14818 ( The subject area has list of entities populated to other ER Diagrams e.g. Logical/Physical shown in the picture above ). The Question is how to get the list of entities displayed under an ER_Diagram
Can you help
Please sign in to leave a comment.