Changes between Version 5 and Version 6 of Developers/WorkingOnTickets

Timestamp:

2017-09-20T01:01:28+02:00 (7 years ago)

Author:

nicolasmartin

Comment:

--

Developers/WorkingOnTickets

@@ -16 +16 @@
 {{{#!td style="text-align: center"
 '''Ticket workflow'''\\
-[[Image(htdocs:tracworkflowadmin/de0849d0f263c422c872b63451b85ffd.png)]]
+[[Image(htdocs:ticket_workflow.png)]]
 }}}
 {{{#!td
@@ -50 +50 @@
 
 {{{#!SQLTable
-SELECT sid FROM session_attribute WHERE value IN ('Administrator', 'Contributor', 'Developer', 'Officer') ORDER BY sid
+SELECT sid As "User", array_agg(value) AS "['Name', 'Office', 'Role']" FROM session_attribute WHERE sid IN (SELECT sid FROM session_attribute WHERE value IN ('Administrator', 'Contributor', 'Developer', 'Officer')) AND name IN ('name', 'role', 'office') GROUP BY sid
 }}}
+
 {{{#!comment
 Don't display the emails !!!