Filter to exclude Packages from an RTF template

[Michel Gibelli]

Hello,

I am trying to buid a Document generation template and I would like to exclude child Packages from the generation (for example packages which do not have a certain stereotype, eg <<myStereo>>).

In the document options, the tab "Element filters" applies only to Element (and not packages).

In the "Document options" tab, there is a textfield 'Except where Query excludes a Package', so I tried to write the custom SQL :
SELECT * FROM t_object where Object_Type = 'Package' and Stereotype <> 'myStereo'
But it did not work. I do not clearly understand the behavior of this field.

Do you have any advice to obtain the result ?
Is it possible or should I change my strategy ?

Thanks in advance
Michel

[Adam@Schneider]

I came across this when I was looking for something else. You need to select the package ID from the t_package table, eg:

SELECT Package_ID AS ExcludePackage
FROM t_package
WHERE t_package.Package_ID = #PACKAGEID#
AND t_package.Name in ('Overview', 'Detailed View')

You may need to subselect on the t_object table because a packages also have elements, and the t_object table stores the stereotype.

Have a play in Edit->Find In Project, you can change to the SQL tab and use that to test your query (ctrl+space auto completes table names like intellisense)

[Michel Gibelli]

One month later  
I would like to thank you.
It helped me.
The reference is in the help (search for "Exclude Package Query and Script")

Michel