Changes between Version 8 and Version 9 of Developers/WorkingOnTickets
- Timestamp:
- 2019-03-07T20:21:59+01:00 (5 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Developers/WorkingOnTickets
v8 v9 50 50 == [=#list Current list of developers/contributors] 51 51 52 {{{#!th 53 System Team \\ 54 (`@dev` group) 55 }}} 56 {{{#!th 57 Contributors \\ 58 (`@contrib` group) 59 }}} 60 |- 61 {{{#!td 62 52 63 {{{#!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 69 ORDER BY p.username 54 70 }}} 55 71 56 {{{#!comment57 Don't display the emails !!!58 [[UserProfilesList({role=Administrator},{role=Contributor},{role=Developer},{role=Officer})]]59 72 }}} 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' 79 ORDER BY sid 80 }}} 81 82 }}}