Hi all,

Appreciate some help trying to build a queryset. Im hoping I can make
this in django, without having to crack open raw sql... Here is my
setup:

class Container(models.Model):
  permissions = generic.GenericRelation(Permission)

class Item(models.Model):
  container = models.ForeignKey(Container)
  extraSetting = models.ForeignKey(ExtraSetting)

class Permission(models.Model):
  content_type = models.ForeignKey(ContentType)
  content_object = generic.GenericForeignKey()
  extraSetting =   models.ForeignKey(ExtraSetting)

class ExtraSetting(models.Model):
  ....

Convoluted made up example, but hopefully you can see what the data
might be.

So the problem im trying to solve. I need to get a list of items and
their permissions, but restrict the permission set so that I only get
permissions where extraSetting is the same on the Item and on the
permission.

So I want to run something like

Item.objects.filter(container__permissions__extraSetting=Item.extraSetting)

Hope this makes some form of sense...

thanks

guardbadger

-- 
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.

Reply via email to