Items Conveyed in database - simple answer

[minna]

After struggling for a while (and reading through several posts with loooong queries), here is my answer to the problem   :
(this is for sql server)

Search for all the entries is t_xref where the behaviour is conveyed
Select Client, Description From t_xref Where Behavior = 'conveyed'

The Client uid is the ea_guid for the connector:
Select * From t_connector Where ea_guid = '<connector (Client) id here>'

The Description gives all the ea_guids of the items conveyed in the connector: (assuming it is an object like Information Item)
Select * From t_object Where ea_guid = '<conveyed item (Description) id here>'

Note: There can be several conveyed item ids in the Description. The above query only allows 1 to be entered.

So no long queries, but you have to do them one by one. At least now you now know the connection between the tables to get to conveyed items