Hello friends, I have a little problem with a relationship with 3 tables
tables
- User
- Transaction
- TransactionDetail
my query is
class TransactionInitiated(generics.ListAPIView):
"""
List Transaction Initiated
"""
serializer_class = TransactionSerializer
def get_object(self, pk):
user = User.objects.get(id=pk)
transaction = Transaction.objects.filter(user_id=user.id,
current_status=0)
# Transactiondetail.objects.filter(transaction_id=transaction.id,
status=0)
return Transaction.objects.filter(user_id=user.id,
current_status=0).order_by('-id')
def get(self, request, pk, format=None):
current_user = request.user
list_trans_init = self.get_object(current_user.id)
serializer = TransactionSerializer(list_trans_init, many=True)
return JsonResponse({'data': serializer.data}, safe=False)
with this query I recovery all user with a respective transaction, but I
don't how to use inner join in here, I try next
def get_object(self, pk):
user = User.objects.get(id=pk)
transaction = Transaction.objects.filter(user_id=user.id, current_status=0)
return Transaction_Detail.objects.filter(transaction_id=transaction,
status=0)
in here return me the next error
more than one row returned by a subquery used as an expression.
please some help me.
thanks for your attention.
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/2ea9259d-19de-4c10-be8d-34df2b0aa66c%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
