REDMINE study » History » Version 5
Marc Dexet, 17/01/2018 18:03
| 1 | 1 | Marc Dexet | h1. REDMINE study |
|---|---|---|---|
| 2 | 1 | Marc Dexet | |
| 3 | 1 | Marc Dexet | Ensemble de requêtes SQL |
| 4 | 1 | Marc Dexet | |
| 5 | 1 | Marc Dexet | h2. Compréhension de l'usage de REDMINE |
| 6 | 1 | Marc Dexet | |
| 7 | 3 | Marc Dexet | Cherchons à comprendre les transitions par tracker |
| 8 | 1 | Marc Dexet | |
| 9 | 3 | Marc Dexet | <pre><code class="sql"> |
| 10 | 3 | Marc Dexet | select COUNT(*) AS total, trackers.name, old_st.name AS "from_status", new_st.name AS "to_status" |
| 11 | 3 | Marc Dexet | FROM journals j, journal_details jd, issues, issue_statuses old_st, issue_statuses new_st, trackers |
| 12 | 3 | Marc Dexet | WHERE issues.id = j.journalized_id |
| 13 | 3 | Marc Dexet | AND j.id = jd.journal_id |
| 14 | 3 | Marc Dexet | AND issues.tracker_id = trackers.id |
| 15 | 3 | Marc Dexet | AND prop_key = 'status_id' |
| 16 | 3 | Marc Dexet | AND old_st.id = old_value::integer AND new_st.id = value::integer |
| 17 | 3 | Marc Dexet | GROUP BY trackers.name, from_status, to_status ORDER BY name, total DESC; |
| 18 | 3 | Marc Dexet | </code></pre> |
| 19 | 3 | Marc Dexet | |
| 20 | 3 | Marc Dexet | h3. Cas Feedback et WaitForValidation |
| 21 | 3 | Marc Dexet | |
| 22 | 3 | Marc Dexet | Le statut Feedback est peu utilisé. Il est l'est surtout pour le tracker PRODUCTION (cf. annexe ) |
| 23 | 3 | Marc Dexet | Le statut WaitForProduction l'est beaucoup plus. |
| 24 | 3 | Marc Dexet | |
| 25 | 3 | Marc Dexet | |
| 26 | 3 | Marc Dexet | |
| 27 | 1 | Marc Dexet | h3. Cas NewDev |
| 28 | 1 | Marc Dexet | |
| 29 | 1 | Marc Dexet | <pre><code class="sql"> |
| 30 | 2 | Marc Dexet | select COUNT(*) as total, t.name, u.login |
| 31 | 2 | Marc Dexet | FROM issues i, trackers t, users u |
| 32 | 2 | Marc Dexet | WHERE i.author_id = u.id AND t.id = i.tracker_id AND t.id = 4 |
| 33 | 2 | Marc Dexet | GROUP BY t.name, login |
| 34 | 2 | Marc Dexet | ORDER BY total DESC, login; |
| 35 | 1 | Marc Dexet | </code></pre> |
| 36 | 1 | Marc Dexet | |
| 37 | 1 | Marc Dexet | <pre> |
| 38 | 1 | Marc Dexet | total | name | login |
| 39 | 1 | Marc Dexet | -------+--------+---------- |
| 40 | 1 | Marc Dexet | 74 | NewDev | kdassas |
| 41 | 1 | Marc Dexet | 60 | NewDev | scaminad |
| 42 | 1 | Marc Dexet | 53 | NewDev | palinger |
| 43 | 1 | Marc Dexet | 30 | NewDev | ccossou |
| 44 | 1 | Marc Dexet | 24 | NewDev | gwang |
| 45 | 1 | Marc Dexet | 20 | NewDev | hballans |
| 46 | 1 | Marc Dexet | 14 | NewDev | |
| 47 | 1 | Marc Dexet | 7 | NewDev | cpidanci |
| 48 | 1 | Marc Dexet | 6 | NewDev | svingata |
| 49 | 1 | Marc Dexet | 5 | NewDev | ebuchlin |
| 50 | 1 | Marc Dexet | 5 | NewDev | esoubrie |
| 51 | 1 | Marc Dexet | 5 | NewDev | mmebsout |
| 52 | 1 | Marc Dexet | 3 | NewDev | bhasnoun |
| 53 | 1 | Marc Dexet | 3 | NewDev | mdexet |
| 54 | 1 | Marc Dexet | 2 | NewDev | ilajili |
| 55 | 1 | Marc Dexet | 1 | NewDev | aarondel |
| 56 | 1 | Marc Dexet | 1 | NewDev | abeelen |
| 57 | 1 | Marc Dexet | 1 | NewDev | cruizdeg |
| 58 | 1 | Marc Dexet | 1 | NewDev | naghanim |
| 59 | 1 | Marc Dexet | |
| 60 | 3 | Marc Dexet | </pre> |
| 61 | 3 | Marc Dexet | |
| 62 | 3 | Marc Dexet | |
| 63 | 3 | Marc Dexet | h2. Annexes |
| 64 | 3 | Marc Dexet | |
| 65 | 3 | Marc Dexet | h3. Transitions de status par tracker |
| 66 | 3 | Marc Dexet | |
| 67 | 3 | Marc Dexet | <pre> |
| 68 | 3 | Marc Dexet | total | name | from_status | to_status |
| 69 | 3 | Marc Dexet | -------+---------------------------+------------------------+------------------------ |
| 70 | 3 | Marc Dexet | 260 | Action | New | Closed |
| 71 | 3 | Marc Dexet | 43 | Action | New | In Progress |
| 72 | 3 | Marc Dexet | 34 | Action | In Progress | Closed |
| 73 | 3 | Marc Dexet | 30 | Action | New | Resolved |
| 74 | 3 | Marc Dexet | 18 | Action | Resolved | Closed |
| 75 | 3 | Marc Dexet | 15 | Action | In Progress | Waiting For Validation |
| 76 | 3 | Marc Dexet | 9 | Action | New | Waiting For Validation |
| 77 | 3 | Marc Dexet | 8 | Action | Waiting For Validation | Closed |
| 78 | 3 | Marc Dexet | 3 | Action | In Progress | Resolved |
| 79 | 3 | Marc Dexet | 3 | Action | New | Rejected / Cancelled |
| 80 | 3 | Marc Dexet | 2 | Action | Waiting For Validation | Resolved |
| 81 | 3 | Marc Dexet | 2 | Action | Resolved | In Progress |
| 82 | 3 | Marc Dexet | 1 | Action | Feedback | Resolved |
| 83 | 3 | Marc Dexet | 1 | Action | Waiting For Validation | Rejected / Cancelled |
| 84 | 3 | Marc Dexet | 1 | Action | In Progress | Feedback |
| 85 | 3 | Marc Dexet | 1 | Action | Closed | In Progress |
| 86 | 3 | Marc Dexet | 1 | Action | Rejected / Cancelled | Closed |
| 87 | 3 | Marc Dexet | 1 | Action | Resolved | Waiting For Validation |
| 88 | 3 | Marc Dexet | 1 | Action | New | Feedback |
| 89 | 3 | Marc Dexet | 1 | Action | Closed | Resolved |
| 90 | 3 | Marc Dexet | 1 | Action | In Progress | Rejected / Cancelled |
| 91 | 3 | Marc Dexet | 1 | Action | In Progress | New |
| 92 | 3 | Marc Dexet | 47 | Bug | New | Closed |
| 93 | 3 | Marc Dexet | 14 | Bug | New | Waiting For Validation |
| 94 | 3 | Marc Dexet | 13 | Bug | New | In Progress |
| 95 | 3 | Marc Dexet | 13 | Bug | Waiting For Validation | In Progress |
| 96 | 3 | Marc Dexet | 6 | Bug | New | Rejected / Cancelled |
| 97 | 3 | Marc Dexet | 6 | Bug | In Progress | Waiting For Validation |
| 98 | 3 | Marc Dexet | 5 | Bug | Resolved | Closed |
| 99 | 3 | Marc Dexet | 4 | Bug | New | Resolved |
| 100 | 3 | Marc Dexet | 3 | Bug | In Progress | Closed |
| 101 | 3 | Marc Dexet | 3 | Bug | Waiting For Validation | Closed |
| 102 | 3 | Marc Dexet | 2 | Bug | Waiting For Validation | Resolved |
| 103 | 3 | Marc Dexet | 1 | Bug | Resolved | In Progress |
| 104 | 3 | Marc Dexet | 1 | Change request CR | New | In Progress |
| 105 | 3 | Marc Dexet | 1 | Change request CR | New | Feedback |
| 106 | 3 | Marc Dexet | 3 | Configuration | New | Waiting For Validation |
| 107 | 3 | Marc Dexet | 2 | Configuration | Waiting For Validation | Closed |
| 108 | 3 | Marc Dexet | 1 | Design | New | Closed |
| 109 | 3 | Marc Dexet | 53 | Documentation | New | In Progress |
| 110 | 3 | Marc Dexet | 47 | Documentation | New | Closed |
| 111 | 3 | Marc Dexet | 46 | Documentation | In Progress | Closed |
| 112 | 3 | Marc Dexet | 11 | Documentation | In Progress | Waiting For Validation |
| 113 | 3 | Marc Dexet | 9 | Documentation | Waiting For Validation | In Progress |
| 114 | 3 | Marc Dexet | 4 | Documentation | New | Waiting For Validation |
| 115 | 3 | Marc Dexet | 3 | Documentation | Waiting For Validation | Resolved |
| 116 | 3 | Marc Dexet | 3 | Documentation | Waiting For Validation | Closed |
| 117 | 3 | Marc Dexet | 2 | Documentation | Resolved | In Progress |
| 118 | 3 | Marc Dexet | 2 | Documentation | Closed | In Progress |
| 119 | 3 | Marc Dexet | 2 | Documentation | Resolved | Closed |
| 120 | 3 | Marc Dexet | 1 | Documentation | In Progress | Resolved |
| 121 | 3 | Marc Dexet | 1 | Documentation | New | Rejected / Cancelled |
| 122 | 3 | Marc Dexet | 22 | Feature | New | Closed |
| 123 | 3 | Marc Dexet | 14 | Feature | New | In Progress |
| 124 | 3 | Marc Dexet | 9 | Feature | Resolved | Closed |
| 125 | 3 | Marc Dexet | 5 | Feature | In Progress | Waiting For Validation |
| 126 | 3 | Marc Dexet | 5 | Feature | Waiting For Validation | Resolved |
| 127 | 3 | Marc Dexet | 5 | Feature | In Progress | Resolved |
| 128 | 3 | Marc Dexet | 5 | Feature | New | Waiting For Validation |
| 129 | 3 | Marc Dexet | 4 | Feature | New | Resolved |
| 130 | 3 | Marc Dexet | 4 | Feature | Waiting For Validation | In Progress |
| 131 | 3 | Marc Dexet | 3 | Feature | Resolved | In Progress |
| 132 | 3 | Marc Dexet | 1 | Feature | In Progress | Closed |
| 133 | 3 | Marc Dexet | 1 | Feature | Waiting For Validation | Closed |
| 134 | 3 | Marc Dexet | 1 | Feature | New | Feedback |
| 135 | 3 | Marc Dexet | 14 | Infrastructure | New | Closed |
| 136 | 3 | Marc Dexet | 7 | Infrastructure | Resolved | Closed |
| 137 | 3 | Marc Dexet | 6 | Infrastructure | New | In Progress |
| 138 | 3 | Marc Dexet | 4 | Infrastructure | In Progress | Resolved |
| 139 | 3 | Marc Dexet | 3 | Infrastructure | New | Resolved |
| 140 | 3 | Marc Dexet | 2 | Infrastructure | In Progress | Closed |
| 141 | 3 | Marc Dexet | 1 | Infrastructure | New | Rejected / Cancelled |
| 142 | 3 | Marc Dexet | 1 | Infrastructure | In Progress | Waiting For Validation |
| 143 | 3 | Marc Dexet | 1 | Infrastructure | Waiting For Validation | Closed |
| 144 | 3 | Marc Dexet | 9 | Meeting | New | Closed |
| 145 | 3 | Marc Dexet | 4 | Meeting | New | In Progress |
| 146 | 3 | Marc Dexet | 3 | Meeting | In Progress | Closed |
| 147 | 3 | Marc Dexet | 78 | NewDev | New | Closed |
| 148 | 3 | Marc Dexet | 54 | NewDev | New | In Progress |
| 149 | 3 | Marc Dexet | 27 | NewDev | Resolved | Closed |
| 150 | 3 | Marc Dexet | 18 | NewDev | In Progress | Closed |
| 151 | 3 | Marc Dexet | 15 | NewDev | In Progress | Waiting For Validation |
| 152 | 3 | Marc Dexet | 14 | NewDev | New | Resolved |
| 153 | 3 | Marc Dexet | 13 | NewDev | Waiting For Validation | In Progress |
| 154 | 3 | Marc Dexet | 13 | NewDev | In Progress | Resolved |
| 155 | 3 | Marc Dexet | 10 | NewDev | New | Waiting For Validation |
| 156 | 3 | Marc Dexet | 8 | NewDev | New | Rejected / Cancelled |
| 157 | 3 | Marc Dexet | 7 | NewDev | Waiting For Validation | Closed |
| 158 | 3 | Marc Dexet | 5 | NewDev | Waiting For Validation | Resolved |
| 159 | 3 | Marc Dexet | 2 | NewDev | Resolved | Waiting For Validation |
| 160 | 3 | Marc Dexet | 2 | NewDev | Resolved | In Progress |
| 161 | 3 | Marc Dexet | 1 | NewDev | Feedback | Resolved |
| 162 | 3 | Marc Dexet | 1 | NewDev | In Progress | Feedback |
| 163 | 3 | Marc Dexet | 1 | NewDev | Waiting For Validation | Rejected / Cancelled |
| 164 | 3 | Marc Dexet | 1 | NewDev | New | Feedback |
| 165 | 3 | Marc Dexet | 1 | NewDev | In Progress | New |
| 166 | 3 | Marc Dexet | 2 | Non-conformance NC | Resolved | Closed |
| 167 | 3 | Marc Dexet | 2 | Non-conformance NC | In Progress | Closed |
| 168 | 3 | Marc Dexet | 2 | Non-conformance NC | New | In Progress |
| 169 | 3 | Marc Dexet | 2 | Non-conformance NC | In Progress | Waiting For Validation |
| 170 | 3 | Marc Dexet | 1 | Non-conformance NC | Closed | Resolved |
| 171 | 3 | Marc Dexet | 1 | Non-conformance NC | In Progress | Resolved |
| 172 | 3 | Marc Dexet | 1 | Non-conformance NC | Waiting For Validation | Closed |
| 173 | 3 | Marc Dexet | 1 | Non-conformance NC | New | Closed |
| 174 | 3 | Marc Dexet | 21 | Production | New | Closed |
| 175 | 3 | Marc Dexet | 6 | Production | New | Feedback |
| 176 | 3 | Marc Dexet | 5 | Production | In Progress | Closed |
| 177 | 3 | Marc Dexet | 4 | Production | New | In Progress |
| 178 | 3 | Marc Dexet | 3 | Production | Feedback | Closed |
| 179 | 3 | Marc Dexet | 3 | Production | Closed | In Progress |
| 180 | 3 | Marc Dexet | 2 | Production | Resolved | Closed |
| 181 | 3 | Marc Dexet | 2 | Production | New | Resolved |
| 182 | 3 | Marc Dexet | 1 | Production | New | Waiting For Validation |
| 183 | 3 | Marc Dexet | 2 | Request for Deviation RFD | New | In Progress |
| 184 | 3 | Marc Dexet | 1 | Request for Deviation RFD | In Progress | Waiting For Validation |
| 185 | 3 | Marc Dexet | 1 | Request for Deviation RFD | Resolved | Closed |
| 186 | 3 | Marc Dexet | 1 | Request for Deviation RFD | Waiting For Validation | Closed |
| 187 | 3 | Marc Dexet | 1 | Request for Deviation RFD | In Progress | Closed |
| 188 | 3 | Marc Dexet | 3 | Support | New | Waiting For Validation |
| 189 | 3 | Marc Dexet | 3 | Support | New | Closed |
| 190 | 3 | Marc Dexet | 3 | Support | New | In Progress |
| 191 | 3 | Marc Dexet | 2 | Support | Waiting For Validation | In Progress |
| 192 | 3 | Marc Dexet | 1 | Support | Feedback | Closed |
| 193 | 3 | Marc Dexet | 1 | Support | Resolved | Closed |
| 194 | 3 | Marc Dexet | 1 | Support | Waiting For Validation | Closed |
| 195 | 3 | Marc Dexet | 1 | Support | In Progress | Waiting For Validation |
| 196 | 3 | Marc Dexet | 19 | Test | New | Closed |
| 197 | 3 | Marc Dexet | 10 | Test | New | In Progress |
| 198 | 3 | Marc Dexet | 9 | Test | Resolved | Closed |
| 199 | 3 | Marc Dexet | 6 | Test | In Progress | Closed |
| 200 | 3 | Marc Dexet | 6 | Test | New | Resolved |
| 201 | 3 | Marc Dexet | 4 | Test | In Progress | Resolved |
| 202 | 3 | Marc Dexet | 1 | Test | Resolved | Waiting For Validation |
| 203 | 3 | Marc Dexet | 1 | Test | New | Rejected / Cancelled |
| 204 | 3 | Marc Dexet | 1 | Test | Closed | In Progress |
| 205 | 3 | Marc Dexet | 1 | Test | Waiting For Validation | Closed |
| 206 | 4 | Marc Dexet | </pre> |
| 207 | 3 | Marc Dexet | |
| 208 | 3 | Marc Dexet | h3. Cas de Feedback |
| 209 | 3 | Marc Dexet | |
| 210 | 3 | Marc Dexet | <pre> |
| 211 | 3 | Marc Dexet | total | name | from_status | to_status |
| 212 | 3 | Marc Dexet | -------+-------------------+-------------+----------- |
| 213 | 3 | Marc Dexet | 1 | Action | New | Feedback |
| 214 | 3 | Marc Dexet | 1 | Action | In Progress | Feedback |
| 215 | 3 | Marc Dexet | 1 | Action | Feedback | Resolved |
| 216 | 3 | Marc Dexet | 1 | Change request CR | New | Feedback |
| 217 | 3 | Marc Dexet | 1 | Feature | New | Feedback |
| 218 | 3 | Marc Dexet | 1 | NewDev | New | Feedback |
| 219 | 3 | Marc Dexet | 1 | NewDev | Feedback | Resolved |
| 220 | 3 | Marc Dexet | 1 | NewDev | In Progress | Feedback |
| 221 | 3 | Marc Dexet | 6 | Production | New | Feedback |
| 222 | 3 | Marc Dexet | 3 | Production | Feedback | Closed |
| 223 | 3 | Marc Dexet | 1 | Support | Feedback | Closed |
| 224 | 1 | Marc Dexet | |
| 225 | 4 | Marc Dexet | |
| 226 | 1 | Marc Dexet | </pre> |
| 227 | 5 | Marc Dexet | |
| 228 | 5 | Marc Dexet | h3. Répartition des trackers par usage (en pourcentage) |
| 229 | 5 | Marc Dexet | |
| 230 | 5 | Marc Dexet | <pre> |
| 231 | 5 | Marc Dexet | redmine_default=# select count(t.name)*100 / ( SELECT count(*) from issues i ) AS total, t.name from issues i, trackers t where i.tracker_id = t.id GROUP BY name ORDER BY total DESC; |
| 232 | 5 | Marc Dexet | total | name |
| 233 | 5 | Marc Dexet | -------+--------------------------- |
| 234 | 5 | Marc Dexet | 41 | Action |
| 235 | 5 | Marc Dexet | 20 | NewDev |
| 236 | 5 | Marc Dexet | 10 | Documentation |
| 237 | 5 | Marc Dexet | 7 | Bug |
| 238 | 5 | Marc Dexet | 4 | Production |
| 239 | 5 | Marc Dexet | 4 | Feature |
| 240 | 5 | Marc Dexet | 3 | Test |
| 241 | 5 | Marc Dexet | 2 | Infrastructure |
| 242 | 5 | Marc Dexet | 1 | Meeting |
| 243 | 5 | Marc Dexet | 1 | Support |
| 244 | 5 | Marc Dexet | 0 | Configuration |
| 245 | 5 | Marc Dexet | 0 | Change request CR |
| 246 | 5 | Marc Dexet | 0 | Request for Deviation RFD |
| 247 | 5 | Marc Dexet | 0 | Non-conformance NC |
| 248 | 5 | Marc Dexet | 0 | Design |
| 249 | 5 | Marc Dexet | |
| 250 | 5 | Marc Dexet | </pre> |