Conveyed Information Items in the database?

[Hermelin]

Hi,

I'm trying to find out where information about conveyed items (for informationflows) are stored in the database?

My goal: Given a certain element I want to find out if it is present in any informationflow as an conveyed item.

Thank you for your help!

[Helmut Ortmann]

Hi,

search in the forum for conveyed items (Automation Interface, 1 year or longer).

You'll find your information.

Helmut

[KP]

Start with an empty database, add the simplest model you can, and look in the t_object, t_connector and t_xref tables. In particular, look at the GUIDs. (Sorry, I don't remember the exact details off the top of my head, but that should get you started).

[Geert Bellekens]

As suggested by Helmut, use the search.
This post was one of the first results: Where are Items Conveyed Stored in the Database?

Geert

[Hermelin]

Many thanks for the link, Geert!

But I'm puzzled, since I did search. When I search with the "Search the Forum" on the upper right hand I don't get any hits on "conveyed items", except this thread.   I didn't know it searched ddifferently than the search-page. No wonder I never find anything on this forum!

[qwerty]

This "Search the forum" is just to confuse the Russians (like we used to say in times of the Cold War).  Sparx seems to use it to frustrate their users. It never finds anything useful. Use the Search [highlight]button[/highlight] top left

q.

[Hermelin]

To help anyone how in the future finds this thread and thinks that the above linked SQL query indeed is "a bit lengthy".


A SQL query to get all relationships a conveyed items is used in:

SELECT Client FROM t_xref WHERE Behavior=\"Conveyed\" AND Description LIKE \"*" + ElementGUID + "*\"";

Note: This query is for usage with the API and this uses * as wildcard. If accessing the database directly use % instead.

[Eve]

Note: This query is for usage with the API and this uses * as wildcard. If accessing the database directly use % instead.

More specifically, use * for running against .eap files, % for anything else regardless of the method being used.

[minna]

After struggling for a while, here is my simple 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