Advertisement
mafinar

Query

May 23rd, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Python 0.42 KB | None | 0 0
  1. from .models import Borrows, AddressInfo
  2. from django.db.models import Subquery, OuterRef, Value as V
  3. from django.db.models.functions import Concat
  4.  
  5. Borrows.objects.annotate(
  6.     full_address=Subquery(
  7.         AddressInfo.objects.filter(phone_number=OuterRef("address")).annotate(
  8.             full_address=Concat(V("{\"district\": \""), "district", V("\", \"upazila\": \""), "upazila", V("\"}"))).values("full_address")))
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement