Dear Django Peoples, I had a small problems with my filters : I am trying to add the “distinct” function to my sentence, but it seems not working when it is mix with the order_by filter. This is working : my_objects_list = Peoples_Push.objects.all().filter(mail__length__lt = 100).order_by(‘-the_…

Find objects with mix Distinct and Order_by

PierreFalque April 5, 2022, 1:58pm 5

Sorry I am french and my english is not very good.
I found the problem, the item in the DISTINCT and the ORDER_BY mus t be the same
this is not possible :
.order_by(’-the_date’).distinct(‘the_mail’)

Topic		Replies	Views
At a loss with ordering by one field and making distinct on another Using Django	3	1083	August 10, 2020
How to select from select distinct ? Forms & APIs	2	1100	September 25, 2022
how to using `order_by` from relate model combine with `distinct` Forms & APIs	10	2575	November 17, 2022
Django ORM `queryset.distinct()` gets duplicate values due to `.ordered_by()` on the column Using the ORM	2	6061	July 10, 2023
Possible to use distinct() with attributes created via extra() in Django ORM? Using Django	2	972	September 6, 2020

Find objects with mix Distinct and Order_by

Related topics