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.