changeset 78:d15cd451b5a9

getMembersWithProjects
author casties
date Wed, 08 May 2013 10:33:39 +0200
parents 96b71e761dac
children 7f26c8e6c8e9
files MPIWGProjects.py
diffstat 1 files changed, 2 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- a/MPIWGProjects.py	Tue May 07 17:38:50 2013 +0200
+++ b/MPIWGProjects.py	Wed May 08 10:33:39 2013 +0200
@@ -1616,7 +1616,8 @@
         
         Returns a list of member keys.
         """
-        #res = self.executeZSQL("select * from projects_members where lower(member_key) = %s", [key.lower()])
+        res = self.executeZSQL("select distinct member_key from projects_members")
+        return [r.member_key for r in res]
         
         
     security.declareProtected('View management screens', 'changeProjectTree')