Re: List view for all projects - Georger Araujo - com.mysql.lists.eventum-users

12 messages in com.mysql.lists.eventum-usersRe: List view for all projects

From	Sent On	Attachments
Joakim Abel	21 Apr 2005 05:56
Joao Prado Maia	21 Apr 2005 12:47
Georger Araujo	25 Apr 2005 05:11
Georger Araujo	28 Apr 2005 04:45
Eric Frazier	28 Apr 2005 08:20
Joao Prado Maia	28 Apr 2005 08:41
Eric Frazier	28 Apr 2005 08:59
Eric Frazier	28 Apr 2005 10:55
Elan Ruusamäe	29 Apr 2005 06:36
Bryan Alsdorf	02 May 2005 05:42
Eric Frazier	02 May 2005 07:14
R P Herrold	02 May 2005 13:03

Subject:	Re: List view for all projects
From:	Georger Araujo (geor...@yahoo.com.br)
Date:	04/28/2005 04:45:51 AM
List:	com.mysql.lists.eventum-users

Now this is better.

SELECT prj_title, usr_full_name, count(iss_id) AS qtd_issue FROM eventum_issue LEFT OUTER JOIN eventum_project ON iss_prj_id = prj_id LEFT OUTER JOIN eventum_user ON iss_usr_id = usr_id GROUP BY iss_prj_id, iss_usr_id ORDER BY prj_title, usr_full_name

I'll try to integrate this into the stats screen for people with profile 'Admnistrator'.

Georger

I have the same idea, and I hacked a query that more or less gives me the information I want (sloppy SQL, I'm not really good with databases):

select u.usr_full_name, p.prj_title, count(iu.isu_iss_id) as qtd_issue, u.usr_full_name from eventum_user u, eventum_issue i, eventum_issue_user iu, eventum_project p, eventum_status s where u.usr_status = 'active' and iu.isu_iss_id = i.iss_id and i.iss_prj_id = p.prj_id and i.iss_sta_id = s.sta_id and s.sta_is_closed <> 1 group by p.prj_title order by u.usr_full_name;

The query lists the number of open issues per project per user. I suppose it wouldn't be too difficult to include the output of this query in the Overall Stats box of the Stats screen. Of couse, it would be necessary to check whether the current user is the manager for the projects, and only list the totals for those projects. It would also be nice to let users know the total number of issues they have open in all projects, especially when they are participating in a large number of projects. We'd have to remove u.usr_full_name from the output (it would be derived from the conext of the currenly user) and the ORDER BY clause; those are only here because I'm querying MySQL directly (I'm not really good with PHP).

Georger

Joakim,

Is there an easy way to manipulate eventum to

have a view

that lists the issues in all managed projects.

As I see it it would take a severe change in the code since the application seems to be built on the basis tht everything is project related.

There is no easy way to do this right now, and you are correct in noticing that this would require big changes on

the code.

However I would really have some kind of input

in this matter since I

believe it would give the support coordinator a real good oversight of what issues to keep track of, no matter what projects they are related to.

That's true, it would indeed be useful on this case.

--Joao

Yahoo! Acesso Grátis - Internet rápida e grátis. Instale o discador agora! http://br.acesso.yahoo.com/

-- Eventum Users Mailing List For list archives: http://lists.mysql.com/eventum-users To unsubscribe: