hey, please don't shoot me if i got it wrong. but i would try this:
report = Reports.objects.filter(author__in = [John, Karl, Jens, Sepp] Maybe you have to create a more suitable list with Author objects. let me know, if this has solved your issue. On Nov 27, 9:43 am, izzy <[EMAIL PROTECTED]> wrote: > Okay, thanks. That would be my last resort.. > > But not all users can create reports. I only want to users that have > created a report.. I doubt that django don't support this kind of > query. I hope not. > > let me elaborate it again. > > Reports have following fields in models.py: > title > category > author = model.ForeignKey(django.contrib.auth.models.User) > .... > > reports = Reports.objects.all() > > #I want to retrieve author values (these should be unique) from the > reports query > authors = ??? # in mySQL these would be: SELECT author from Reports > where ... > > Please help --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---