Author Topic: Query to list the requirements from a use case  (Read 1854 times)

Mario Rodriguez Jaen

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Query to list the requirements from a use case
« on: July 12, 2011, 08:52:14 pm »
hi there,

I was trying to figure out how to get the requirements from a use case? I know I can see both types of objects from the t_object table, but I´m unable to find from which table to get the relationship.

thanks,
Mario

Mario Rodriguez Jaen

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Query to list the requirements from a use case
« Reply #1 on: July 12, 2011, 09:02:30 pm »
Okay i think I got it:

It would be something like:

select * from t_connector
where connector_type = 'Realisation'

and from there i can get the:
  • start_object_id
  • end_object_id

David Rains (bioform)

  • EA User
  • **
  • Posts: 83
  • Karma: +0/-0
    • View Profile
Re: Query to list the requirements from a use case
« Reply #2 on: July 14, 2011, 10:30:52 pm »
Of course that would ONLY give you the EXTERNAL requirements (linked by a realization association to the element). The internal requirements would be located elsewhere I believe.

David

carolin.boeckler

  • EA User
  • **
  • Posts: 34
  • Karma: +0/-0
    • View Profile
Re: Query to list the requirements from a use case
« Reply #3 on: January 15, 2014, 11:25:36 pm »
SELECT * FROM t_objectrequires