Book a Demo

Author Topic: Simple SQL  (Read 4168 times)

Maggie

  • EA User
  • **
  • Posts: 106
  • Karma: +0/-0
    • View Profile
Simple SQL
« on: August 13, 2014, 07:13:33 pm »
Hello
I want to write a simple SQL statement to find a model element by its name but dont really know where to start.
I would be grateful if someone could provide some hints on how I can do this

Thanks

Maggie

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: Simple SQL
« Reply #1 on: August 13, 2014, 08:31:06 pm »
Press Ctrl-F
Click the New Search icon top left
Select Query Editor and supply a name
Enter
Code: [Select]
SELECT o.ea_guid AS CLASSGUID, o.Object_Type As CLASSTYPE, o.Name
FROM t_object o WHERE o.Name = '<Search Term>'
Note that copy/paste has flaws. Type "SELECT" manually and paste the rest
Save and run the search.

Also have a look in my Inside book.

q.
« Last Edit: August 13, 2014, 08:31:53 pm by qwerty »

Maggie

  • EA User
  • **
  • Posts: 106
  • Karma: +0/-0
    • View Profile
Re: Simple SQL
« Reply #2 on: August 13, 2014, 09:33:37 pm »
Thanks qwerty :)