iro/controller/viewinterface.py
branchdevel
changeset 120 7bde35ad89e0
parent 119 3462c2c90f95
child 121 ca63b6776231
--- a/iro/controller/viewinterface.py	Sat Jan 28 04:03:15 2012 +0100
+++ b/iro/controller/viewinterface.py	Sat Jan 28 04:03:46 2012 +0100
@@ -141,8 +141,8 @@
 
 
         '''
-        user = session.query(User).filter_by(name=user.name).first()
-        return [u.offer_name for u in user.rights if u.isDefault == True]
+        offers = session.query(Userright.offer_name).join(Offer,User).filter(and_(User.name==user.name,Offer.typ==typ,Userright.isDefault==True))
+        return [u[0] for u in offers]
 
     @vUser
     def statistic(self, user):