SQL - Macro #Branch#: Result entire model

[Pegasus]

Hello,

I am just testing #Branch# Macro with some case
and is see that result seems to be entire modell wheater if selected package contains further packages  or not? I expecte #Branch contains
Query:
select o.ea_guid AS CLASSGUID, o.Object_Type AS CLASSTYPE, o.name, o.ea_guid, o.Object_type AS Type, o.Stereotype, o.Author, o.modifiedDate AS Modified, o.note AS [Notes] FROM t_object o, t_package pkg WHERE pkg.Package_ID IN (#Branch#)

from user guide
http://sparxsystems.com/enterprise_architect_user_guide/13.0/model_navigation/creating_filters.html
Gets the IDs of the child Packages of the currently-selected Package, working recursively down to the lowest level of sub-Package. For example:
t_object.Package_ID IN (#Branch#)

Thanks
Pegasus

[Geert Bellekens]

I've used #Branch# is lots of search queries, and it has never failed me.

Have you tried running a project integrity check?

Geert

[OpenIT Solutions]

Hi,

Your query is missing a join, try :

select o.ea_guid AS CLASSGUID, o.Object_Type AS CLASSTYPE, o.name, o.ea_guid, o.Object_type AS Type, o.Stereotype, o.Author, o.modifiedDate AS Modified, o.note AS [Notes] FROM t_object o, t_package pkg WHERE pkg.Package_ID IN (#Branch#)
AND o.package_ID = pkg.Package_ID

Regards,

Jon.