Book a Demo

Author Topic: Find where I use an operation?  (Read 4869 times)

Hilario Grun

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Find where I use an operation?
« on: June 19, 2008, 05:47:43 am »
I have defined an  OPERATION who is used on many sequence diagrams.
How I found on who sequence diagrams I use this OPERATION?
« Last Edit: June 19, 2008, 05:50:14 am by HilarioGrun »

Hilario Grun

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Find where I use an operation?
« Reply #1 on: June 27, 2008, 04:24:45 am »
I made a query like this.
XXXXXXX - is the operation name
-------------------------------------
SELECT distinct
t_diagram.Name diagrama
FROM t_object
 INNER JOIN (t_package
INNER JOIN (t_connector
INNER JOIN t_diagram
ON t_connector.DiagramID = t_diagram.Diagram_ID)
 ON t_package.Package_ID = t_diagram.Package_ID)
ON t_object.Object_ID = t_connector.Start_Object_ID
WHERE
t_connector.Name Like '%XXXXXXX%'

«Midnight»

  • EA Guru
  • *****
  • Posts: 5651
  • Karma: +0/-0
  • That nice Mister Grey
    • View Profile
Re: Find where I use an operation?
« Reply #2 on: June 27, 2008, 05:24:38 am »
Looks OK to me. Did it work?
No, you can't have it!

Hilario Grun

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Find where I use an operation?
« Reply #3 on: July 02, 2008, 12:14:33 am »
Yes.
I used.
Of course, I have do have access on the exact database where I created EA tables
« Last Edit: July 02, 2008, 12:16:25 am by HilarioGrun »

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8110
  • Karma: +119/-20
    • View Profile
Re: Find where I use an operation?
« Reply #4 on: July 02, 2008, 08:09:42 am »
Just a few suggestions for using this with EA's search mechanism.

  • Adding 't_diagram.ea_guid as CLASSGUID' to your search will allow EA to directly open the diagram from the search window.
  • '#WC#' will be replaced by the wildcard for the current database.
  • '<Search Term>' will be replaced by the text being searched for.