Problem:
For some big model I would like to find an Attribute, but do not know which Entity it belongs to. Is there a way to find the Entity Name of a given Attribute (like when using Ctrl+G for finding Entities) in a model?
Solution:
Entities are already arranged alphabetically so it is easy to manage to go to them. However, a same named Attribute can be in a number of Entities. Searching for them could be tricky, especially if the Entity Name is not known. If you like you can use ODBC Query tool to find the Entity of a specific Attribute. Here is the query you can use:
Select
TRAN(E.Name) AS 'Entity Name',
TRAN(A.Name) AS 'Atribute_Name'
From
Entity E
Join Attribute A On
A.Owner@ = E.ID@
Where
TRAN(A.Name) like '%Print_%' ; --> replace the name with actual Attribute name
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center