I’m trying to create an Django ORM query to replace a really messy raw SQL query i’ve written in the past but i’m not sure if Django ORM can let me do it. I have three tables: contacts id company_id 1 1 2 2 custom_fields id field_name 1 name 2 email 3 phone 4 name 5 …

I’m thinking of something like this - there may be a mistake or ten here since I’m winging it - subquery1 = Subquery(ContactCustomFieldValue.objects.filter(contact=OuterRef('id'), custom_field_id=1).values_list('value')) subquery2 = ... subquery3 = ... subquery4 = ... contact_list = Contact.object…

Django ORM query with user defined fields

Using Django Using the ORM

Lexicade July 14, 2022, 2:44pm 8

Yes, exactly. 4 known fields that every contact will have by default. Anything else they have doesn’t matter for this, we just want those 4

Topic		Replies	Views
Dynamic raw query (select clause) Django ORM	13	2298	April 5, 2022
How to perform group by on couple of columns and fetch multiple columns from multiple table using Django ORM Using the ORM	34	6966	February 28, 2023
Finding matching objects from two models using the ORM Using the ORM	3	1228	February 9, 2024
Union on two querysets mixes the data. Using the ORM	7	84	March 5, 2025
data in orm not exactly fetched as sql Using the ORM	4	34	November 14, 2024

Django ORM query with user defined fields

Related topics