Hello,
I'm making a menu bar for my website, and this menu bar will display
according to the permissions of the group that the user is in.
I've defined an optional foreign key 'group' for the menuitem model:
from django.db import models
from django.contrib.auth.models import Group
class menuitem(models.Model):
name = models.CharField(max_length=30)
parent = models.ForeignKey('self', blank=True, null=True)
* group = models.ForeignKey(Group, blank=True, null=True)*
The idea is to be able to query all the items that have a specific
'group' record chosen, as well as all items that don't have anything
set. Since some of them can be NULL or None, how do I go about selecting
in a query both the items that are NULL, as well as the items that are
linked to a specific 'group' in the related table?
This does not work:
*qs = menuitem.objects.all().filter(group__in=[None, 1])
*
This works:
qs = menuitem.objects.all().filter(group=None)
This works:
qs = menuitem.objects.all().filter(group=1)
Thanks for your help with this.
J
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
