Messages

1

General Board / SQL search relations between nested objects with conveyed item

« on: November 09, 2019, 01:32:59 am »

Hi,

I have a Component diagram. There are Components with Ports connected by Information Flow. Information Flow has Items conveyed.
I need to create list of all relationships within the diagram (to generate integration catalog out of the diagram). As all the Components are placed in one Package as a reusable assets, I need to filter the search on the level of diagram, or maybe specific Tagged Value

I have tried following search (TOP 50 is used only for debug because many objects are within the database):

Code: [Select]

SELECT TOP 50
  PRODUCER.Stereotype AS Producer_Type,
      PRODUCER.Name AS Producer_Name,
  CONSUMER.Stereotype AS Consumer_Type,
      CONSUMER.Name AS Consumer_Name,
  CONNECTOR.Name AS Purpose,
      CONNECTOR.Stereotype AS Connector_Type,
      CONVEYED.Stereotype AS Conveyed_Type,
      CONVEYED.Name AS Data_Entity,
      PACKAGE.Name AS Package,
  DIAGRAM.Name AS Diagram,
  TAGS.Property AS Tag_Name,
  TAGS.VALUE AS Tag_Value
FROM t_xref XCONVEYED, t_object CONVEYED,
      t_object PRODUCER, t_object CONSUMER,
      t_connector CONNECTOR, t_object PACKAGE,
  t_diagram DIAGRAM, t_objectproperties TAGS
WHERE XCONVEYED.Behavior='conveyed'
      AND XCONVEYED.Description LIKE '%' + CONVEYED.ea_guid + '%'
      AND CONNECTOR.Start_Object_ID=PRODUCER.Object_ID
      AND CONNECTOR.End_Object_ID=CONSUMER.Object_ID
      AND CONNECTOR.ea_guid = XCONVEYED.Client
  AND DIAGRAM.Name = 'Relations search'

but this will select only direct relations between ports without superior Component. And even the filtering doesn't work

any idea?

2

General Board / Re: Relationship Matrix use with "apply Model search" and SQL query (EA 14.1)

« on: August 09, 2019, 09:01:42 pm »

Hi Geert,

thanks, that helped. Solved

Tomas

3

General Board / Re: Relationship Matrix use with "apply Model search" and SQL query (EA 14.1)

« on: August 06, 2019, 04:21:40 pm »

Hi,

I'm trying to use model search within the relationship matrix. I'm searching all objects, which have specific Tagged value
My select is:
select c.ea_guid as CLASSGUID, c.object_type as CLASSTYPE, c.name as Name, c.alias as Alias, c.stereotype as Stereotype
from (t_object c
inner join t_objectproperties op on op.Object_ID = c.Object_ID)
where op.Property = 'domain'
and op.Value like 'Customer'

I'm able to navigate from the search into Project Browser, but unfortunately it won't retrieve list of objects in Relationship matrix.

I'm using SparX EA Corporate edition version 14.1

Thanks for heplp