Mercurial > hg > MPIWGWeb
comparison MPIWGProjects.py @ 178:ee0fbb711f17
fix problem with mixed case person keys
| author | casties |
|---|---|
| date | Tue, 11 Jun 2013 17:51:55 +0200 |
| parents | 7fe39dcfb6c1 |
| children | 136b2d5b3e3d |
comparison
equal
deleted
inserted
replaced
| 177:a7be6992777e | 178:ee0fbb711f17 |
|---|---|
| 1951 | 1951 |
| 1952 Returns a list of member objects. | 1952 Returns a list of member objects. |
| 1953 """ | 1953 """ |
| 1954 members = [] | 1954 members = [] |
| 1955 sf = self.en.getStaffFolder() | 1955 sf = self.en.getStaffFolder() |
| 1956 res = self.executeZSQL("select distinct member_key from projects_members") | 1956 res = self.executeZSQL('select distinct lower(member_key) as "member_key" from projects_members') |
| 1957 if onlyActive: | 1957 if onlyActive: |
| 1958 for r in res: | 1958 for r in res: |
| 1959 m = sf.getMember(key=r.member_key) | 1959 m = sf.getMember(key=r.member_key) |
| 1960 if m is not None and m.isActive(): | 1960 if m is not None and m.isActive(): |
| 1961 members.append(m) | 1961 members.append(m) |