Re: values with distinct not working as expected

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 <tuxcanfly@gmail.com> 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 django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
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 django-users@googlegroups.com.
To unsubscribe from this group, send email to django-users+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.