# HG changeset patch
# User casties
# Date 1368002019 -7200
# Node ID d15cd451b5a900c1e7381498216b77eda70cf97d
# Parent  96b71e761dac5b50edd66ff7bf10b61f2292cd4f
getMembersWithProjects

diff -r 96b71e761dac -r d15cd451b5a9 MPIWGProjects.py
--- 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')