Hi, this reminds me of an issue I had a while ago: http://groups.google.com/group/django-users/browse_thread/thread/a4679cb9a42c6ba1/1e76718aa0097628?lnk=gst&q=julien+q#1e76718aa0097628 I haven't checked lately but there might still be a bug.
Julien On Feb 9, 8:08 am, Oliver Beattie <[EMAIL PROTECTED]> wrote: > Hi People, > > I'm trying to write a query using Q objects but I'm getting incredibly > frustrated with them. I'm afraid I don't know SQL so I wouldn't know > how to write the queries by hand! The query (using Q objects) I am > trying to construct is:- > > media = media.filter( > Q(owner=requester) | > Q(user_permission__granted_to=requester, > user_permission__privilege__icontains=privilege) | > Q(group_permission__granted_to__members=requester, > group_permission__privilege__icontains=privilege) | > Q(tags__user_permission__granted_to=requester, > tags__user_permission__privilege__icontains=privilege) | > Q(tags__group_permission__granted_to__members=requester, > tags__group_permission__privilege__icontains=privilege) > ) > > I think most people would be able to figure out what I wanted there! > The SQL this generates can be seen athttp://dpaste.com/34377/if this > helps anyone. I'm running out of ideas of what to try next. > > Can anyone help me? Is there another way I could go about this? > > Any help would be appreciated immensely, > Oliver --~--~---------~--~----~------------~-------~--~----~ 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
