sort two joined querysets - django

Question

I have a join of two querysets:

fqs= FirstModel.objects.all()
sqs= SecondModel.objects.all()
sorted_qs = sorted(chain(fqs, sqs)) #<- need to sort here by "added" field.

both models have this added field.

added = models.DateTimeField(auto_add_now=true)

but sorted_qs is giving me each time different order. I think, chain joins them randomly each time..

I need to sort by certain fieldname. how do i do this?

score 3 · Accepted Answer · edited May 23 '17 at 12:06

3

sorted needs to know the key:

sorted_qs = sorted(chain(fqs, sqs), key=lambda obj: obj.added)

edited May 23 '17 at 12:06

Community

answered Mar 09 '14 at 19:06

Gabriel Amram

then add reverse=True – Gabriel Amram Mar 09 '14 at 19:18
1

@doniyor Or just use `lambda obj: -obj.added` – Steinar Lima Mar 09 '14 at 19:26

1 Answers1