5
Most database engines don’t like relational comparisons with NULL values. Use <field>__isnull to explicitly check if a value is NULL in the database, but you’ll need to use Q objects to OR the conditions together.
17
Flip the logic and use exclude(). What you really want to do is exclude any data that specifies a date that doesn’t fit. If pickup_latest and pickup_earliest are NULL it shouldn’t match the exclude query and wont be removed. Eg
exclude['pickup_latest__lt'] = d['available_on']
exclude['pickup_earliest__gt'] = d['available_on']
0
Don’t think that’s actually a django-specific question. Variable ‘d’ is a python dictionary, no? If so, you can use this:
filter['pickup_latest__gte'] = d.get('available_on', None)
- [Django]-Django openid authentication with google
- [Django]-Django app not found despite adding to INSTALLED_APPS?
Source:stackexchange.com