mercredi 13 juillet 2016

Django Subquery with Scalar Value

Is it possible to compare subqueries results with scalar values using Django ORM? I'm having a hard time to convert this: SELECT payment_subscription.* FROM payment_subscription payment_subscription JOIN payment_recurrent payment_recurrent ON payment_subscription.id = payment_recurrent.subscription_id WHERE payment_subscription.status = 1 AND (SELECT expiration_date FROM payment_transaction payment_transaction WHERE payment_transaction.company_id = payment_subscription.company_id AND payment_transaction.status IN ('OK', 'Complete') ORDER BY payment_transaction.expiration_date DESC, payment_transaction.id DESC LIMIT 1) <= ? The main points are: The last comparison of the scalar value of the subquery with an arbitrary parameter. the join between the subquery and the outer query with the company id

Aucun commentaire:

Enregistrer un commentaire