CSE report of Model Entity Types that do not have any Relationships

Products

• Gen

Issue/Introduction

How to create a Gen Client Server Encyclopedia (CSE) report of Model Entity Types that do not have any Relationships?

Environment

Gen Client Server Encyclopedia (CSE)

Resolution

1. Using the CSE Encyclopedia Client run a Object Cross Reference Report on the model, selecting Report Type of "Contains" and then select all the Entity Types in the model. That will include Relationships where they exist so the report can be manually scanned for Entity Types that do not have any. For further details please see:
Use the Client Server Encyclopedia > Encyclopedia Reports > Object Cross-Reference Reports


2. Alternatively SQL can be used and for each relationship in the model the CSE Public Interface view RELATIONSHIP contains 2 rows representing each direction of the relationship. This SQL can be run to join the PI views ENTITY_TYPE, RELATIONSHIP & MODEL to build a list of Entity Types for a particular model that are not used in any relationship e.g. 

select E.NAME from ENTITY_TYPE E, MODEL M
where M.NAME='MODEL_NAME' 
and E.MODEL_ID=M.ID 
and E.ID not in (select SOURCE_ENTITY_ID from RELATIONSHIP);

For further details please see the Client Server Encyclopedia Public Interface