Book a Demo

Author Topic: How to show a textual overview of relations at attribute level?  (Read 4881 times)

evelien.van.veen

  • EA Novice
  • *
  • Posts: 5
  • Karma: +0/-0
    • View Profile
How to show a textual overview of relations at attribute level?
« on: September 04, 2016, 11:15:45 pm »
I draw relationships between attributes of a logical model and columns of a physical model in a diagram.
On the diagram is only a little subset of all objects and tables.

I want a textual overview from the relations between the attributes and columns shown on the diagram.

I can get the relational information when I document the whole model but that is far to much.
When I try to query I can get relations on object/table-level but not on attribute/column level.

How can I get the information on the diagram in a textual form, like rtf-document or as a result of some query or somehowe else?


« Last Edit: September 04, 2016, 11:24:19 pm by evelien.van.veen »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How to show a textual overview of relations at attribute level?
« Reply #1 on: September 05, 2016, 12:07:16 am »
Evelien,

You can use an SQL query to get that information.
Usually I use SQL searches for that purpose because they are both useful inside EA, and easy to export to csv.
There are a few treads on this forum that discuss the internal structure of the "link to element feature". Using the search function you should be able to find them and figure out how to write the query.

Geert

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: How to show a textual overview of relations at attribute level?
« Reply #2 on: September 05, 2016, 01:09:45 am »
Am I right when assuming that you use Link to Related for the relations?

q.