If you don't want to uniquify yourself, then why not simply do:
User.objects.values('username').order_by('username').distinct()
or, going the way that were already heading, it would be:
Visitor.objects.values('user__username').order_by('user__username'').distinct()
Thanks,
Subhranath Chunder.
On Thu, Jul 29, 2010 at 2:29 PM, tuxcanfly <[email protected]> wrote:
> I have this:
>
> class Visitor(models.Model):
> user = models.ForeignKey(User)
> ......
> ......
>
> I'm trying to get the distinct usernames, so I did this:
>
> Visitor.objects.values("user__username").distinct()
>
> But this stil gives me duplicate usernames. Of course I could use a
> flat values_list and uniquify the result, but...
>
> --
> You received this message because you are subscribed to the Google Groups
> "Django users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<django-users%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/django-users?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected].
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.
