Developing a Traceability SQL

[mvngomes]

I am trying here as well and still couldn't figure it out. I think the left ones are not a problem, they worked for me. Anyone else out there has any clues?

[Geert Bellekens]

Normally it is mainly a question of adding enough brackets, but I can't seem to get this one working.

Geert

[mvngomes]

I appreciate your help a lot, Geert. It's the same for me here. I run out of ideas on what to do.

I payed attention for possible problems with the brackets but they seem fine. MS Access does accept left joins. I really am stuck now.

Of course, having EA run on top of MySQL is an option, but I don't want to assume all of the people using the add-in I am working on will have their EA set up like that. I'll keep on trying. I still wonder if the search I was looking for could be done with t_connector only, just for making it more compact.

Again, thank you very much! Hope we'll hear from someone who managed to get this right.

[stao]

you can try out our SQLRepository in modus number 1 (no full database checkout)
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1322259105

I am trying to get a query that works in SQL because doing that using the EA repository object model is pretty slow - it's easy to write a method to do that, but the performance was not the best.

the code will be the same. you only have to use the created SQLRepository for you search.
for a specific database search of ours the duration decreased from 0.91sec to 0.22sec. (depends on you code).

[Geert Bellekens]

Hi,

I've you are not planning to use the sql query in an sql search then there's more possible of course.
I guess you then only need to the object id's, and you don't need to join with t_object at all.

Geert