thank you for your answer, but I need a next result
select * select User as u inner join transaction as tr on u.id=user_id.id
inner join transactionDetail as trd on tr.id=trd.transaction_id
where tr.current_status=trd.status
please how can I do that
thanks for your attention.
On Thursday, March 8, 2018 at 1:25:00 PM UTC-2, C. Kirby wrote:
>
> As written it looks like you want to get all the 0 status transactions for
> a given user, and then get all the transaction details for those
> transactions (.filter allows for any number of results) Since your var
> transaction is a list, and you really only care about the ids to pull the
> transaction details, you should have your code like this:
>
> def get_object(self, pk):
> user = User.objects.get(id=pk)
> transactions = Transaction.objects.filter(user_id=user.id,
> current_status=0).values_list('id', flat=True)
> return Transaction_Detail.objects.filter(transaction_id__in=
> transactions, status=0)
>
>
>
> On Thursday, March 8, 2018 at 9:52:44 AM UTC-5, Angel Rojas wrote:
>>
>> 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/e8b0c942-178d-4dd0-95eb-a9a797663851%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
