# HG changeset patch
# User casties
# Date 1370965915 -7200
# Node ID ee0fbb711f17a4e648be89b209cb4f4fe370b39d
# Parent  a7be6992777e8cd1f20a9c7cc066b4b8eea3e322
fix problem with mixed case person keys

diff -r a7be6992777e -r ee0fbb711f17 MPIWGProjects.py
--- a/MPIWGProjects.py	Tue Jun 11 14:46:52 2013 +0200
+++ b/MPIWGProjects.py	Tue Jun 11 17:51:55 2013 +0200
@@ -1953,7 +1953,7 @@
         """
         members = []
         sf = self.en.getStaffFolder()
-        res = self.executeZSQL("select distinct member_key from projects_members")
+        res = self.executeZSQL('select distinct lower(member_key) as "member_key" from projects_members')
         if onlyActive:
             for r in res:
                 m = sf.getMember(key=r.member_key)