Changes between Version 25 and Version 26 of Developers/SVN_QuickReference

Timestamp:

2017-12-08T14:37:17+01:00 (7 years ago)

Author:

nicolasmartin

Comment:

--

Developers/SVN_QuickReference

@@ -15 +15 @@
 {{{#!td
 {{{#!SQLTable
-SELECT value AS "Name" FROM session_attribute 
-WHERE
-name IN ('name')
-AND
-sid IN (SELECT sid FROM session_attribute WHERE name = 'role' AND value = 'Officer')
+SELECT value AS "Name" FROM session_attribute
+WHERE name IN ('name') AND sid IN (SELECT sid FROM session_attribute WHERE name = 'role' AND value = 'Officer')
 }}}
 }}}
@@ -25 +22 @@
 {{{#!SQLTable
 SELECT value AS "Office" FROM session_attribute 
-WHERE
-name IN ('office')
-AND
-sid IN (SELECT sid FROM session_attribute WHERE name = 'role' AND value = 'Officer')
+WHERE sid IN (SELECT sid FROM session_attribute WHERE name = 'role' AND value = 'Officer') AND name = 'office'
 }}}
 }}}
-[[UserProfilesList(role=Officer)]]
 
 === For external users