Issues with GUID of onnectors / relationships

[Viking]

It did neither work on eap nor on MariaDB. I will try again.

[Viking]

Hi @Geert, many thanks for your patience. On my installation these attributes doe not exist:

Code: [Select]

SELECT * FROM t_diagramlinks ->  t_diagramlinks does not have a Connector_lD, use Instance_ID instead
SELECT * FROM t_connector -> t_connector does not have a ConnectorID, but a Connector_ID instead

So this SQL-statement works:

Code: [Select]

SELECT d.ea_guid AS DiagramName
FROM ((t_diagramlinks dl
JOIN t_diagram d ON dl.DiagramID = d.Diagram_ID)
join t_connector c on c.Connector_ID = dl.Instance_ID)
WHERE c.ea_guid = '{BEFFA34C-4A29-46d0-AE21-96723A6FEC29}'

I thought that I was using the newest schema. I just set it up newly yesterday.

[Geert Bellekens]

Instance_ID is something else. You need connectorID
I just verified, and this one actually works

Code: [Select]

SELECT *
FROM ((t_diagramlinks dl
JOIN t_diagram d ON dl.DiagramID = d.Diagram_ID)
join t_connector c on c.Connector_ID = dl.ConnectorID)
WHERE c.ea_guid = '{BEFFA34C-4A29-46d0-AE21-96723A6FEC29}'
The schema is unfortunately not consistent with the usage of underscores. Most of the times there's an underscore in "_ID" but sometimes not.

Geert

Geert

[Viking]

@Geert, I got yours to work. But I had to change c.connectorID into c.connector_ID.