Given object definitions as rows and columns in a Spreadsheet (lovingly hand-crafted or retrieved via Query), is there any way to show attributes of the connections between them (when that connection is unique if existent)? The IS_CONNECTED_BY/QUERY_IS_CONNECTED spreadsheet formulas can only answer the question if there is a connection.
Alternatively, for a similar Matrix, can an attribute value of their connection be shown rather than just the existence of a connection?
Use case: in information models, we have Entity Types which may share ERM Attribute objects connected to each ET object via is describing for (78), is primary key for (80), is foreign key for (79) connections. I want to get a table with Entity Types as columns, ERM Attributes as rows, with an X if they have a connection of any of these types, and that connection has a boolean attribute Mandatory with value equal to true.
It would be nice not to have to go the report route.
Hello Pontus,
indeed queries are the way to go. You can define the connection as a query step in your query definition. Then you can pull that into the result spreadsheet and use the techniques to display attributes for that connection just the same as you do for objects in the query path.
In the example shown above you can pull the "carries out" step into your result spreadsheet and use the subsequent column for attributes of that connection type.
In the definition of the query you can choose, if you want incoming, outgoing or both directions of connections of a certain type.