Search-based Report

[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
o.Stereotype ="ABOPackage"
q.

See corrected quote above. Of course you need o.stereotype.

You should check out my book (see link below). When you look into the t_package description you will find out why you need t_object for the query.


q.

[Geert Bellekens]

q,

Are you sure about the join between t_object and t_package?
I would do:

Code: [Select]

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

[Stefan Bolleininger]

Hi,

is that really, what SaZ wants? i assume SaZ wants to have the full iterative report on the package.

The query surely give the right packageelement but it is needed to runReport on the package to get all its content.

That would be my assumption for this topic.

possibility: you can package.runreport on the package from the query and use a specific template for this.

[RoyC]

SaZ, if you have not already done so, I think you need to contact Sparx Support, either with a Bug Report (use the link in the Support column at the bottom of this page) or as an email to [email protected].

Other members of the community are having an active discussion of your problem, but it looks as if you are not finding it easy to understand them. Get Support to help you.

[SaZ]

I tried out all the queries that you gave me and a implemented other ones. Many of them find the right package, BUT THE PROBLEM IS LIKE I SAID, THAT WHEN I APPLY THE TEMPLATE ON THE PACKAGE THAT I FOUND, THE TEMPLATE INTERPRETS THE FOUND PACKAGE AS A SIMPLE ELEMENT AND NOT AS A PACKAGE WITH ALL HIS ELEMENTS IN IT!!!

So I really think this is a bug...or do you have some TESTED SOLUTION  for my case???

Thank you very much!
Sam

[RoyC]

Sam, I'm not sure that you realise that you are addressing other users such as yourself. The people who are trying to help you are not Sparx Systems employees, and have no obligation to respond to you. This is a USER forum and Sparx employees only join it on a casual basis - again, they have no obligation to respond to users through this channel.

Please contact Sparx Support for assistance in resolving your problem.