Book a Demo

Author Topic: External reuirements in DB  (Read 2710 times)

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
External reuirements in DB
« on: July 25, 2007, 03:20:13 am »
External requirements in DB are objects (which is OK).
The problem is that I haven't found a way to connect them to their related object.
Does any one know how?
THanks
Recursion definition:
If you don’t understand the definition read "Recursion definition".

Martin Terreni

  • EA User
  • **
  • Posts: 672
  • Karma: +0/-0
  • Sorry, I can't write
    • View Profile
Re: External reuirements in DB
« Reply #1 on: July 25, 2007, 03:33:15 am »
I found it!

SELECT     dbo.t_object.Object_ID AS ReqID, dbo.t_object.Name AS ReqName, t_object_1.Object_ID AS ObjID, t_object_1.Name AS ObjName

FROM         dbo.t_connector INNER JOIN

                     dbo.t_object AS t_object_1 ON dbo.t_connector.Start_Object_ID = t_object_1.Object_ID INNER JOIN

                     dbo.t_object ON dbo.t_connector.End_Object_ID = dbo.t_object.Object_ID

WHERE     (dbo.t_object.Object_Type = N'Requirement') AND (dbo.t_connector.Connector_Type = N'Realisation')
« Last Edit: July 25, 2007, 03:33:52 am by martint »
Recursion definition:
If you don’t understand the definition read "Recursion definition".