I have a custom permissions system in a django project that can link any user to any specific model instance to grant permission on that object. It is more complex than this, but boiled down: I want to query for all permissions for any user, that are linked to the same content_object(s) that a particular user…
Tag: django-orm
Django – complicated ORM Query (related_set)
I have model Car, Listing and Website. I want to filter all car objects that have listing object on the given website but the listing needs to be active. To get all car objects that have listing object on the given website: But how do I filter out inactive listings? I want something like: Answer You would do …
Django ORM filter multiple fields using ‘IN’ statement
So I have the following model in Django: My goal is to have all the tuples grouped by the member with the most recent date. There are many ways to do it, one of them is using a subquery that groups by the member with max date_time and filtering member_loyalty with its results. The working sql for this solutio…
Subquery django query to get biggest disctint values from objects and return those objects
So I have this query that I need to re-filter to get just the biggest taken_at field’s value from distinct meter id, but I cannot get the django orm’s/sql part to makes this query. <QuerySet [<Reading: [127] meter installation: 29, type: 1, taken: 2019-10-07 16:06:48.101453+00:00 value: 78.0…
Filtering Django Query by the Record with the Maximum Column Value
Is there an easy way to filter a Django query based on which record has a max/min value in a column? I’m essentially asking these questions, but in the specific context of Django’s ORM. e.g. Say I have a model designed to store the historical values of everyone’s phone numbers. with the reco…