EmForge - Task #97994 : REPORTS: Implement 'All Tasks' report

REPORTS: Implement 'All Tasks' report	Process Started: 7 months ago
Task is Closed	Process Finished: 7 months ago

Workflow:	ImplementAFeature
Started by:	akakunin	Priority:	High
Project:	EmForge	Milestone:	EmForge-0.23
Process Due Date:		Developer:	szakusov

Description

This report should display all Active tasks in the system - for all projects, users and milestones.

Comments (8)

Posted by akakunin 7 months ago

It has 'High' priority since it is user-request. I hope it is quite easy to implement.

Posted by szakusov 7 months ago

Done in [#2897]. See ActiveTasks.jrxml

Posted by akakunin 7 months ago

Look at this report in EmForge: http://www.emforge.org/report/ActiveTasks.jrxml

Task "Implement Posibility to send any report by click a button" repeats starting from EmForge-0.18

If seems you get milestone values from TaskInstance variables - but need to get it from ProcessInstance variables (completed task instances will contain old values).

Posted by szakusov 7 months ago

The problem has been introduced by fix another bug related to executing JasperReports on HSQLDB - the problem was in the query:


...
INNER JOIN JBPM_VARIABLEINSTANCE vProj ON (vProj.PROCESSINSTANCE_ = task.ID_) AND (vProj.NAME_ = '_Project')        AND (vProj.TOKENVARIABLEMAP_ IS NOT NULL)
LEFT  JOIN JBPM_VARIABLEINSTANCE vMile ON (vMile.PROCESSINSTANCE_ = task.ID_) AND (vMile.NAME_ = '_Milestone')      AND (vMile.TOKENVARIABLEMAP_ IS NOT NULL)
...

it turned out, that HSQLDB cannot make LEFT JOIN with vMile.TOKENVARIABLEMAP_ IS NOT NULL) condition!!!

Posted by szakusov 7 months ago

MyRecentTasks.jrxml has been fixed too (in [#2899])

Posted by akakunin 7 months ago

Still not ok - if you will look at the report - EmForge-0.23 milestone splitted into several parts.

Posted by szakusov 7 months ago

It turned out, that JasperReports groups result rows according its order! :o

So I've just added proj.DISPLAYNAME and mile.DISPLAYNAME to order criteria too.

Checked in [#2906]

Posted by akakunin 7 months ago

Now it is ok.

to add comment

Attachments (2)

2008-04-10 01:46:		Start New Process
2008-04-10 01:46:		End Task: Request a Feature
2008-04-10 01:47:		End Task: Accept Feature
2008-04-10 01:47:		End Task: Assign Feature to Milestone
2008-04-10 01:47:		End Task: Assign Feature to Developer
2008-04-10 06:41:		End Task: Implement Feature
2008-04-10 07:06:		End Task: Verify Feature Implementation
2008-04-10 08:47:		End Task: Implement Feature
2008-04-10 12:33:		End Task: Verify Feature Implementation
2008-04-11 06:18:		End Task: Implement Feature
2008-04-11 07:05:		End Task: Verify Feature Implementation
2008-04-11 07:05:		Process Finished: Feature Implemented