Author Topic: Find diagrams with model Search  (Read 2783 times)

armin

  • EA User
  • **
  • Posts: 63
  • Karma: +0/-0
  • mission possible
    • View Profile
Find diagrams with model Search
« on: June 23, 2008, 07:13:21 pm »
Hi,

we have a lot of Worddocs containing references to EA-Diagrams. For maintaining purposes it would be very helpful, if EA would provide a possibility in model search to find diagrams by its UID or at least by its name. SQL search is not very comfortable because it offers no possibility for navigation, locating diagram in project browser, etc.

Regards Armin

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Find diagrams with model Search
« Reply #1 on: June 24, 2008, 08:21:38 am »
The Query Builder supports doing queries for diagrams.  The SQL search also handles navigation to a diagram.

Code: [Select]
SELECT ea_guid AS CLASSGUID, Name, Version, Author, StereoType, CreatedDate, ModifiedDate
FROM t_diagram
WHERE <your condition>

armin

  • EA User
  • **
  • Posts: 63
  • Karma: +0/-0
  • mission possible
    • View Profile
Re: Find diagrams with model Search
« Reply #2 on: June 24, 2008, 05:46:19 pm »
Hi Simon,

ea_guid AS CLASSGUID was the cosmic hint. Thank you. Perhaps there is also a solution for using placeholder like in standard model search filter? We could always set the uid in the where clause, but it would be more comfortable just enter a search term in the search dialog.

Best regards
Armin  

Eve

  • EA Administrator
  • EA Guru
  • *****
  • Posts: 8085
  • Karma: +118/-20
    • View Profile
Re: Find diagrams with model Search
« Reply #3 on: June 25, 2008, 08:00:54 am »
Code: [Select]
SELECT ea_guid AS CLASSGUID, Name, Version, Author, StereoType, CreatedDate, ModifiedDate
FROM t_diagram
WHERE ea_guid='<Search Term>'

Have a look at the Recently Modified Searches for some additional tips.