Book a Demo

Author Topic: Find unrealized elements  (Read 4982 times)

Maggie

  • EA User
  • **
  • Posts: 106
  • Karma: +0/-0
    • View Profile
Find unrealized elements
« on: April 01, 2015, 07:35:46 pm »
Hi
I have a package that contains a set of features that are realized by components in another package.
I can use the relationship matrix to show the realisations but what i want is something that tells me which features have not been realised.
Is there a way of showing this

Thanks

Maggie

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Find unrealized elements
« Reply #1 on: April 01, 2015, 08:59:04 pm »
I remember having done that with a little script counting the number of realize relations and spitting out those which did not have any. Since I had my own document generator I got a nice document for that as well.

Going with the EA doc gen (which I simply don't use) you can probably write an SQL doing the same as above and use the found elements to create a report.

A simple search result would probably also serve well :)

q.

Maggie

  • EA User
  • **
  • Posts: 106
  • Karma: +0/-0
    • View Profile
Re: Find unrealized elements
« Reply #2 on: April 01, 2015, 09:03:43 pm »
Thanks

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: Find unrealized elements
« Reply #3 on: April 02, 2015, 09:15:59 am »
This will get you started. It lists all Feature elements that aren't the source of a Realization. Just copy it into the SQL Scratch Pad and run it.

Code: [Select]
SELECT * FROM t_object WHERE Object_Type='Feature' AND Object_ID NOT IN
(SELECT DISTINCT Start_Object_ID FROM t_connector WHERE Connector_Type='Realisation')
The Sparx Team
[email protected]

Maggie

  • EA User
  • **
  • Posts: 106
  • Karma: +0/-0
    • View Profile
Re: Find unrealized elements
« Reply #4 on: April 02, 2015, 06:40:14 pm »
Thanks