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>