Search-based Report

[SaZ]

Hi everyone,

I'm trying to generate a report selecting some packages using an SQL search : SELECT ea_guid AS CLASSGUID, Object_Type AS CLASSTYPE FROM t_object WHERE t_object.Stereotype ="ABOPackage"

The selection works fine, the problem is that when I apply my template to the result of the query, the template reads the result-packages as a simple elements instead of reading it as  packages, and so I don't have all the elements included in the packages in my report...somebody could please help me?

Thank you veeery veeery much!!

[qwerty]

Not sure whether the following would be the solution:

Code: [Select]

SELECT
 p.ea_guid AS CLASSGUID, 'Package' AS CLASSTYPE
FROM t_package p, t_object o
WHERE
 p.package_id = o.package_id and o.object_type = 'Package' AND
t_package.Stereotype ="ABOPackage"
q.

[Geert Bellekens]

I don't even think you need t_object for that.

Geert

[SaZ]

Hi qwerty, the query you gave me return an error: "Too few parameters. Expected 1."

Hi Geert, I don't exactly what you mean to do the query without "t_object" could you please write me the query which you mean??

I'm struggling with this problem since day!! Thank you very much!
Sam

[SaZ]

I cannot write "t_package.Stereotype" this simply doesn't exists!

[SaZ]

This doesn't give me error:
SELECT p.ea_guid AS CLASSGUID, 'Package' AS CLASSTYPE, p.Name FROM t_package p, t_object o WHERE p.package_id = o.package_id and o.object_type = 'Package' AND o.Stereotype ="aBOPackage"

But what I'm getting back is just the super-package of what I'm looking for and this one also just as an Element and not as a package!! How can i get back a package from an SQL-query??? The whole package with all his elements in it?

Tank you very much!!
Sam

[Geert Bellekens]

No, that's not what you want.
The t_object.package_id is the id the the owner package, not the package id of the object (of type package)
You need to use the value in p_data1 to join t_object and t_package

Geert

[SaZ]

Ok I see, but what you mean exactly with "use the value in p_data1"? Can you write me the query? Many many thanks!!!

[SaZ]

The problem is always that I don't get a package back but only an element!! How can I get a package back??

Cheers
Sam

[Geert Bellekens]

from t_package
inner join t_object on t_package.package_ID = t_object.pdata1

but then you have to add the appropriate syntax/casts to make it work depending on your repository type.

Geert

[SaZ]

With the search I really find the package that I want (of type package), but when I apply the template to my result it treats it as a single element istead  of navigate it as a normal package!!

I really need some help! Thank you!!

[SaZ]

from t_package
inner join t_object on t_package.package_ID = t_object.pdata1

but then you have to add the appropriate syntax/casts to make it work depending on your repository type.

Geert

How Can I do a cast? What is pdata1?

[SaZ]

Could you not please write the whole sql-query selecting the Packages having Stereotype-value = 'someStereo' and returning the resulting packages as packages which contains all his subelements and can be used to apply a template on them?

[SaZ]

The query should return results from my own project in EA which I'm actually working on, I'm not using some repository...

[SaZ]

Could anybody please help?? I really need it!!

Sam