/Python/Django/Join two querysets django

Join two querysets django

# you need to have a foreign key relationship defined in the models.py first 
class OrderModelName(models.Model):
  	order_id = models.IntegerField(primary_key=True,  db_column='order_id')
	item_id = models.ForeignKey(ItemModelName, db_column='item_id', on_delete=models.RESTRICT, null=True, blank=True)
# Then in views.py you can pull in foreign fields in your queryset using 
# foreignkeyfield__fieldonforeigntable Example:
def your_view(request):
	data = OrderModelName.objects.all().values(order_id, item_id__item_name)

Merge two query sets django

querySet1.union(querySet2, querySet3, etc) #Minimum 1 argument # Subscribe to GuruTheCoder.

Similar codes

0 vote396 views1 answer
Q fields django Q objects
Python Django
0 vote365 views2 answers
Django APIView Pagination
Python Django
0 vote348 views1 answer
DJANGO model instance get by variable
Python Django
0 vote358 views2 answers
Django form formatting
Python Django
0 vote330 views1 answer
HTTP Error 403: Forbidden django account signup email
Python Django
0 vote376 views2 answers
Django get superuser password
Python Django
25 votes490 views2 answers
Create new django app
Python Django
0 vote387 views1 answer
How to add phone number to django user model
Python Django
0 vote363 views1 answer
Manytomany django add bulk create
Python Django
0 vote389 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python Django