How to merge two differently ordered queryset from same model together one after another in django

Asked Aug 13 '18 at 15:40

Active Aug 13 '18 at 15:58

Viewed 63 times

I have tried

work_orders = WorkOrder.objects.all()

active_wo = work_orders.filter(status=OPEN).order_by('-raised_on')

completed_wo = work_orders.filter(status=COMPLETE).order_by('-completed_on')

But when i merge these above querysets together as

work_orders = completed_wo | active_wo

all i want to get is either active_wo objects followed by completed_wo or viceversa i am not getting proper ordered queryset as i expected. i am getting work_orders in ordered by its pk

Please advice me a solution i need queryset as output as i have many filtering yet to do.

edited Aug 13 '18 at 15:58

asked Aug 13 '18 at 15:40

Susaj S N

https://stackoverflow.com/questions/431628/how-to-combine-2-or-more-querysets-in-a-django-view – Sachin Aug 13 '18 at 15:45
@ Sachin Kukreja. i don't want to sort the resulted list in a particular way. see all i wanted my active_list first then completed_list .or just opposite – Susaj S N Aug 13 '18 at 15:53
`list(chain(...))` method didn't work for you then? – Sachin Aug 13 '18 at 15:54
@Sachin Kukreja it works but i don't want list as result. i want queryset as result dude – Susaj S N Aug 13 '18 at 15:57
i'm facing the same issue – Jinu Aug 13 '18 at 16:04

How to merge two differently ordered queryset from same model together one after another in django

0 Answers0