query with django orm

Question

I need select rows with django orm. I need equivalent of such query

select * from order where (user_from = u and f1 not is null) or (user_to = u and f2 not is null)

I try to do this way:

Order.objects.filter(user_from = self).exclude(f1 = None)+Order.objects.filter(user_to = self).exclude(f2 = None)

But no union in orm.. how can be such task done by orm? (i see one solution to add some fields in my model, but it intresting to solve it without fields adding)

Can you post the source code for Order model?

Manoj Govindan
– Manoj Govindan

2010-08-23 14:00:38 +00:00
Commented Aug 23, 2010 at 14:00 — Manoj Govindan
– Manoj Govindan, Commented Aug 23, 2010 at 14:00

Manoj Govindan · Accepted Answer · 2010-08-23 13:29:11Z

1

Take a look at Q objects. You can execute something like:

Order.objects.filter(
    Q(user_from = u, f1__isnull = False) | Q(user_to = u, f2__isnull = False)
)

Warning: this is untested code. It would be a good idea to see the actual SQL query generated and verify that this is indeed what you need.

edited Aug 23, 2010 at 13:29

answered Aug 23, 2010 at 12:51

Manoj Govindan

75.2k21 gold badges138 silver badges142 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Evg Over a year ago

It get exception: Join on field 'to_url_placed_update' not permitted. Did you misspell 'is_null' for the lookup type? I see it for the first time for using __is_null=False You shure this feature present in django orm?

Manoj Govindan Over a year ago

My mistake. is_null should have been isnull. Upadting answer.

Collectives™ on Stack Overflow

query with django orm

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related