Changes between Version 5 and Version 6 of Developers/Working On Tickets


Ignore:
Timestamp:
2017-09-20T01:01:28+02:00 (3 years ago)
Author:
nicolasmartin
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Developers/Working On Tickets

    v5 v6  
    1616{{{#!td style="text-align: center" 
    1717'''Ticket workflow'''\\ 
    18 [[Image(htdocs:tracworkflowadmin/de0849d0f263c422c872b63451b85ffd.png)]] 
     18[[Image(htdocs:ticket_workflow.png)]] 
    1919}}} 
    2020{{{#!td 
     
    5050 
    5151{{{#!SQLTable 
    52 SELECT sid FROM session_attribute WHERE value IN ('Administrator', 'Contributor', 'Developer', 'Officer') ORDER BY sid 
     52SELECT 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 
    5353}}} 
     54 
    5455{{{#!comment 
    5556Don't display the emails !!!