Book a Demo

Author Topic: How can I get Element using SQL Repository  (Read 3813 times)

mohammed

  • EA User
  • **
  • Posts: 28
  • Karma: +0/-0
    • View Profile
How can I get Element using SQL Repository
« on: June 28, 2013, 08:42:12 pm »
How can I get Element using SQL Repository ,
I have element ID and I want to get element using SQL statement
or
what is the name of the table that contains element data,
 :D
« Last Edit: June 28, 2013, 08:55:39 pm by itman »

qwerty

  • EA Guru
  • *****
  • Posts: 13584
  • Karma: +397/-301
  • I'm no guru at all
    • View Profile
Re: How can I get Element using SQL Repository
« Reply #1 on: June 28, 2013, 09:02:31 pm »
select * from t_object where object_id = <id>;

q.

mohammed

  • EA User
  • **
  • Posts: 28
  • Karma: +0/-0
    • View Profile
Re: How can I get Element using SQL Repository
« Reply #2 on: June 28, 2013, 09:59:19 pm »
not useful .
it returns no objects.

again I need the name of the table that contains the all Elements as xml
with xml IDs.

« Last Edit: June 28, 2013, 10:01:26 pm by itman »

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: How can I get Element using SQL Repository
« Reply #3 on: June 28, 2013, 11:08:19 pm »
you are funny ;D

Geert

Makulik

  • EA User
  • **
  • Posts: 400
  • Karma: +0/-0
    • View Profile
Re: How can I get Element using SQL Repository
« Reply #4 on: June 29, 2013, 12:01:00 am »
Quote
not useful .
it returns no objects.

again I need the name of the table that contains the all Elements as xml
with xml IDs.

There's no such method available AFAIK!

KP

  • EA Administrator
  • EA Expert
  • *****
  • Posts: 2919
  • Karma: +55/-3
    • View Profile
Re: How can I get Element using SQL Repository
« Reply #5 on: July 08, 2013, 11:11:13 am »
[edit]The second half of this thread has been removed because a number of posts did not conform to the Forum's Terms and Conditions regarding name-calling.

Please try to be nice to each other. And when posting please try to provide as much detail as possible in your questions. This makes it easier for people to give more helpful answers in return.

Thanks.[/edit]
« Last Edit: July 08, 2013, 11:12:21 am by KP »
The Sparx Team
[email protected]