Django multiple queryset combine into a pagination

Question

I have combine 2 queryset from different models into a list and used pagination to display as a single list. The problem is the objects from the list are displayed by the pagination according to the models they were created from. How could I fix the list so when a new object is created from the models. It will be displayed after the recently created object even though the recent object created was from a different models. Example would be . I have a combine queryset of user's whiteboard and user's comment. If a new whiteboard 's object was created recently and I would create another comment . The comment would be displayed by the pagination after the whiteboard 's object instead of been displayed with all the other comments further down the paginated because it was in a different models I hope you can get the idea of what i'm trying to achieve :) Parts of my module ``` class WhiteBoard(models.Model): user = models.ForeignKey(User) name = models.CharField(max_length=100) created = mode…

Accepted Answer

You just need to sort your list of combined querysets by the `created` attribute they both share:

```
from itertools import chain
...
posts = list(
            sorted(
                chain(picture,comment),
                key=lambda objects: objects.created,
                reverse=True  # Optional
            ))
paginator = Paginator(posts, 5)
...
```

Here's a similar question on the topic

Django multiple queryset combine into a pagination

Solution

Problem

Related problems