Operations filtered by scope per SQL driven RTF

[Embedded Office]

Hi, I try to generate a report, containing a list of public operations and ,using the same template, for a report of private operations.
To achieve this, I thought to create a SQL Search with search value "public" respective "private". This is my search

Code: [Select]

select fu.ea_guid AS CLASSGUID, 'Operation' AS CLASSTYPE, fu.Scope, fu.Name
from t_operation fu, t_object elem
where elem.Name <> "BSP Reference Implementation"
and  fu.Scope = "<Search Term>"
and elem.Object_ID = fu.Object_IDWorks like charm in the Model Search, but the generated document lists always functions of both scopes.

So what do I do wrong here?

I guess the underlying mechanism is just looking, if an element should be included in the report and if so, processes everything of that element. What I want to avoid is what actually works, namely to make two templates with a filter in "Other Filters" listing Method->Scope->Public, Required

Any help much appreciated.
Wolfgang

[Embedded Office]

Just got word from support that this can't be done with the current version. Have to use the workaround till at least EA 10 comes out.

Thanks to support for the quick reply!

[Graham_Moir]

EA10 ?  May be because I haven't been on here much recently but is that the first time it's been mentioned?