Changes between Version 8 and Version 9 of Developers/Working On Tickets


Ignore:
Timestamp:
2019-03-07T20:21:59+01:00 (19 months ago)
Author:
nicolasmartin
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Developers/Working On Tickets

    v8 v9  
    5050== [=#list Current list of developers/contributors] 
    5151 
     52{{{#!th 
     53System Team \\ 
     54(`@dev` group) 
     55}}} 
     56{{{#!th 
     57Contributors \\ 
     58(`@contrib` group) 
     59}}} 
     60|- 
     61{{{#!td 
     62 
    5263{{{#!SQLTable 
    53 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 
     64  SELECT s.sid AS "ID", s.value AS "Name", p.action AS "Institute" 
     65    FROM session_attribute AS s, permission AS p 
     66   WHERE s.name = 'name' 
     67     AND p.action IN ('@cmcc', '@cnrs', '@mercator', '@meto', '@nerc') 
     68     AND p.username = s.sid 
     69ORDER BY p.username 
    5470}}} 
    5571 
    56 {{{#!comment 
    57 Don't display the emails !!! 
    58 [[UserProfilesList({role=Administrator},{role=Contributor},{role=Developer},{role=Officer})]] 
    5972}}} 
     73{{{#!td 
     74 
     75{{{#!SQLTable 
     76  SELECT sid As "ID", value AS "Name" FROM session_attribute 
     77   WHERE sid IN (SELECT username FROM permission WHERE action = '@contrib') 
     78     AND name = 'name' 
     79ORDER BY sid 
     80}}} 
     81 
     82}}}