Messages

1

General Board / Re: Extracting Conveyed Items using SQL query

« on: September 24, 2021, 11:54:05 pm »

I have the same issue as described here--I think it was never completely answered.  I am trying to basically the same query as Chris--and I have tried to use CAST as suggested by Geert.  I am not sure where else to load my database to practice the queries other than in MS Access, so that is what I am using.  I kept getting an error [Syntax error (missing operator)] when using CAST, but Cvar worked: 

SELECT t_connector.Name, t_object.Name, t_object_1.Name, t_object_2.Name
FROM (((t_connector INNER JOIN t_object ON t_connector.Start_Object_ID = t_object.Object_ID)
INNER JOIN t_object AS t_object_1 ON t_connector.End_Object_ID = t_object_1.Object_ID)
INNER JOIN t_xref ON t_connector.ea_guid = t_xref.Client)
INNER JOIN t_object AS t_object_2 ON Cvar(t_xref.Description) = t_object_2.ea_guid
WHERE (((t_connector.Stereotype)="ResourceExchange") AND ((t_xref.Behavior)="conveyed"));

Now, to see what works in Sparx SQL queries.

2

General Board / Re: Relationship Matrix with multiple targets or updated table from SQL query

« on: May 01, 2021, 12:08:26 am »

Maybe this was too obvious for everyone else so no answers .  Phoned a friend and found the answer in ModelView element.  Whew!

3

General Board / Relationship Matrix with multiple targets or updated table from SQL query

« on: April 10, 2021, 11:11:52 am »

I have been trying to make a requirements traceability verification matrix (and other traceability matrices).  From all my searching, it seems this can't be done directly in the EA Relationship Matrix.  (question has been asked and looked at often: https://sparxsystems.com/forums/smf/index.php/topic,30219.msg220720.html#msg220720).  I have written a SQL query to give me what I am looking for, but I have to use this as a fragment in a custom report.  I just want to be able to keep updating this table to view from within the model.  SQL code is below, but I do not know how to get a table in a diagram to use this.  Alternatively, if anyone has figured out how to have multiple targets for a source in a Relationship Matrix, I can make that work.

This is what shows up from code below (in a table, but I don't know how to get that to show up on this post):

| Requirement ID  | Requirement Text | Verification Method | Test Level | Test Case | Test Responsibility | Test Verdict |
|        001              |  The system shall. |   Inspection             | Bench      | Sample TC|   Someone             | pass           |

Code: [Select]

SELECT ReqID.Value AS ReqID, ReqText.Notes AS ReqText, ReqVfy.Value AS ReqVfy, TestLevel.Value AS TestLevel, TestCase.Name AS TestCase, TestResponsibility.Value AS TestResponsibility, TestVerdict.Value AS TestVerdict
FROM (((((t_objectproperties AS ReqVfy
INNER JOIN (t_objectproperties AS ReqText
INNER JOIN (t_object AS [ReqPackage(RWPResp)]
INNER JOIN t_objectproperties AS ReqID ON [ReqPackage(RWPResp)].Object_ID = ReqID.Object_ID) ON ReqText.Object_ID = [ReqPackage(RWPResp)].Object_ID) ON ReqVfy.Object_ID = [ReqPackage(RWPResp)].Object_ID)
INNER JOIN t_connector AS ReqTestCnctr ON [ReqPackage(RWPResp)].Object_ID = ReqTestCnctr.End_Object_ID)
INNER JOIN t_object AS TestCase ON ReqTestCnctr.Start_Object_ID = TestCase.Object_ID)
INNER JOIN t_objectproperties AS TestLevel ON TestCase.Object_ID = TestLevel.Object_ID)
INNER JOIN t_objectproperties AS TestResponsibility ON TestCase.Object_ID = TestResponsibility.Object_ID)
INNER JOIN t_objectproperties AS TestVerdict ON TestCase.Object_ID = TestVerdict.Object_ID
WHERE ((([ReqPackage(RWPResp)].Package_ID)=104) AND (([ReqPackage(RWPResp)].Object_Type)="Requirement") AND ((ReqID.Property)="id") AND ((ReqText.Property)="text") AND ((ReqVfy.Property)="verifyMethod") AND ((ReqTestCnctr.Stereotype)="verify") AND ((TestLevel.Property)="Test_Level") AND ((TestResponsibility.Property)="Test_Responsibility") AND ((TestVerdict.Property)="Verdict"));
TIA for taking a look.

4

General Board / Re: Left align boundary label?

« on: February 05, 2021, 04:49:38 am »

Man, soooo many years later and this still isn't an option?