DevTeam

h1. REDMINE study

Ensemble de requêtes SQL

h2. Compréhension de l'usage de REDMINE

h3. Cas NewDev

<pre><code class="sql">

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;

</code></pre>

<pre>

 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

</pre>