Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: razzo78 on September 03, 2015, 11:07:51 pm

Title: Effort report
Post by: razzo78 on September 03, 2015, 11:07:51 pm

Hi,
i want to make a report with a summary that contains the sum of all time effort that i had assigned to my elements.
How do i can do?

Thx.

Title: Re: Effort report
Post by: razzo78 on September 04, 2015, 08:46:37 pm

I have found a solution:

1: Create the following query:

SELECT SUM( t_objecteffort.EValue) as Hours
FROM
t_object, t_objecteffort, t_package

WHERE
t_package.Package_id in (#Branch#)
AND t_object.Package_ID = t_package.Package_ID
AND t_object.Object_ID = t_objecteffort.Object_ID

2: I added the query in a fragment template and the fragment template in a template  ::)