In the RTF report template how to filter on the Element connector taget type?

[Mads Kirstan]

Hi,

I'm trying to make a Use Case, where I would like to list realized Features, but not the realized Requirements.
How do I filter on the Connectors target type?

Kind regards.
Mads Kirstan

[Uffe]

Hi Mads,


I'm not the world's greatest expert on RTF document generation (that would be Geert), but I don't think you can set a filter to catch that. I think you'll have to split your template into a "main" one and a fragment.

The fragment RTF should contain the fields you want (probably Name and Description, maybe Alias as well). Its custom query should, given an element, return only those Features which the specified element realizes.


HTH,


/Uffe

[Geert Bellekens]

I don't think I'm the greatest RTF template expert either, but I do think Uffe is correct.

I would probably make an SQL fragment with an sql statement similar to the following

Code: [Select]

select f.Name AS FeatureName, f.Note AS FeatureDescription from (t_object f
inner join t_connector r on (r.End_Object_ID = f.Object_ID
and r.Connector_Type in ('Realization', 'Realisation')))
where r.Start_Object_ID = #OBJECTID#
and f.Object_Type = 'Feature'
And then in the custom section add fields {FeatureName} {FeatureDescription}

Geert

[Mads Kirstan]

Thanks for the input! It worked like a charm 

Maybe an enhancement for next version?

Kind regards
Mads

[skiwi]

Thanks for the input! It worked like a charm 

Maybe an enhancement for next version?

Kind regards
Mads

Only if you submit it as a feature request, please