Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
I have to modify a legacy Django web application where there are 2 tables to store the same information using the same database structure, and the only difference is the names of the tables (and th...
#1: Initial revision
by
toraritte
·
2024-04-13T22:09:38Z (7 months ago)
How to merge Django model query results?
I have to modify a legacy Django web application where there are 2 tables to store the same information using the same database structure, and the only difference is the names of the tables (and the corresponding Django models):
+ `ProgramAAssignments` model for `program_a_assignments` table
+ `ProgramBAssignments` model for `program_b_assignments` table
They have 2 distinct views that query these models like so:
```
ProgramAAssignments.objects.all().order_by('-assignment_date')
ProgramBAssignments.objects.all().order_by('-assignment_date')
```
I decided to leave the database untouched and just combine the views, but don't know how to merge these queries.