On 09-11-19 3:36 PM, Benjamin Wolf wrote:
> I'm trying to create a select with the django query set which should
> give me the same result like this sql statement:
> SELECT distinct(YEAR(`mydate`)) FROM `table`
>
> I've tried it for a while but don't get it.
Try using values in the filter eg:
Disposal.objects.values("mydate").filter(mydate__year__gte=2008).distinct()
The problem is the default django query selects all the fields, messing
up the distinct part.
http://docs.djangoproject.com/en/dev/ref/models/querysets/#values-fields
--
Andy McKay, @clearwind
Training: http://clearwind.ca/training/
Whistler conference: http://clearwind.ca/djangoski/
--
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=.
