--- a/MPIWGProjects.py	Tue May 07 11:14:24 2013 +0200
+++ b/MPIWGProjects.py	Tue May 07 17:38:50 2013 +0200
@@ -1599,16 +1599,24 @@
         projects = []
         # search project numbers
         res = self.executeZSQL("select * from projects_members where lower(member_key) = %s", [key.lower()])
-        tree = self.getProjectTree()
-        # find projects in tree
+        # find projects in folder
         for r in res:
-            p = tree.get(r.project_number)
+            p = self.get(r.project_id, None)
             # check if active
             if p is not None and p.checkActive(active) and p.checkArchived(archived):
                 projects.append(p)
-            
+
+        # sort by project number            
         projects.sort(key=lambda p:[int(n) for n in p.getNumber().split('.')])
-        return projects        
+        return projects
+        
+        
+    def getMembersWithProjects(self):
+        """Return a list of all members that have projects.
+        
+        Returns a list of member keys.
+        """
+        #res = self.executeZSQL("select * from projects_members where lower(member_key) = %s", [key.lower()])
         
         
     security.declareProtected('View management screens', 'changeProjectTree')