Exclude packages from report by Custom SQL

[survex]

Say I have model and I want to exclude all packages which name ends by "--" like following pattern "*--".

I've playing around with Generate Documentation > Options > Except where Query excludes Custom SQL, but can't figure out how it works.

Does anybody has working examples of such query?

[Michel Gibelli]

Hello,

I asked the same question in :
http://www.sparxsystems.com/cgi-bin/yabb/YaBB.cgi?num=1412081849/

and Adam gave me an answer

In my case, I use the following request :
SELECT t_package.Package_ID AS ExcludePackage
FROM t_package, t_object
WHERE t_package.Package_ID = #PACKAGEID#
AND t_object.PDATA1 LIKE t_package.PACKAGE_ID
AND (t_object.stereotype is null or t_object.stereotype <> 'Domaine fonctionnel')

I hope it will help you

Michel

[survex]

Thank you very much!!!

But is there any way to exclude all not only one package found, but all subpackages?

[qwerty]

Recursion in SQL is almost impossible. You could probably hard code a certain depth level. Or you need to use automation.

q.