REDMINE study¶

Ensemble de requêtes SQL

Compréhension de l'usage de REDMINE¶

Cas NewDev¶

select COUNT(*) as total, t.name, u.login 
FROM issues i, trackers t, users u 
WHERE i.author_id = u.id AND t.id = i.tracker_id AND t.id = 4 
GROUP BY t.name, login  
ORDER BY total DESC, login;

 total |  name  |  login
-------+--------+----------
    74 | NewDev | kdassas
    60 | NewDev | scaminad
    53 | NewDev | palinger
    30 | NewDev | ccossou
    24 | NewDev | gwang
    20 | NewDev | hballans
    14 | NewDev |
     7 | NewDev | cpidanci
     6 | NewDev | svingata
     5 | NewDev | ebuchlin
     5 | NewDev | esoubrie
     5 | NewDev | mmebsout
     3 | NewDev | bhasnoun
     3 | NewDev | mdexet
     2 | NewDev | ilajili
     1 | NewDev | aarondel
     1 | NewDev | abeelen
     1 | NewDev | cruizdeg
     1 | NewDev | naghanim