[FIXED] How can I concatenate two different model query and order by a field that both models has

Issue

How can I concatenate two different model query and order by a field that both models has like progress fields.

For example

models.py

class Gig(models.Model):
    author= models.ForeignKey(User)
    title = models.CharFields()
    progress = models.IntegerField()

class Project(models.Model):

    author= models.ForeignKey(User)

    title = models.CharFields()

    progress = models.IntegerField()

Can I do my view.py like this, for me to achieve it?

İf No, How can I achieve it?

views.py

def fetch_all_item(request):
   gig = Gig.objects.filter(author_id = request.user.id)
   project = Project.objects.filter(author_id = request.user.id)
   total_item = (gig + project).order_by("progress")

   return render(request, "all_product.html", {"item": total_item})

I am trying to join two query set from Gig and Project models then send it to frontend in an ordering form by a field name called progress.

Solution

You can let Python do the sorting for you, like:

from operator import attrgetter


def fetch_all_item(request):
    gig = Gig.objects.filter(author=request.user)
    project = Project.objects.filter(author=request.user)
    total_item = sorted([*gig, *project], attrgetter('progress'))
    return render(request, "all_product.html", {'item': total_item})

It might however be better to remodel this to a single model with a type field that disambiguates between a Gig and a Project.

---

Note: It is normally better to make use of the settings.AUTH_USER_MODEL ^[Django-doc] to refer to the user model, than to use the User model ^[Django-doc] directly. For more information you can see the referencing the User model section of the documentation.

Answered By - Willem Van Onsem