Django Tastypie Advanced Filtering: How to do complex lookups with Q objects

by

You are on the right track. However, build_filters is supposed to transition resource lookup to an ORM lookup.

The default implementation splits the query keyword based on __ into key_bits, value pairs and then tries to find a mapping between the resource looked up and its ORM equivalent.

Your code is not supposed to apply the filter there only build it. Here is an improved and fixed version:

def build_filters(self, filters=None):
    if filters is None:
        filters = {}
    orm_filters = super(BusinessResource, self).build_filters(filters)

    if('query' in filters):
        query = filters['query']
        qset = (
                Q(name__icontains=query) |
                Q(description__icontains=query) |
                Q(email__icontains=query)
                )
        orm_filters.update({'custom': qset})

    return orm_filters

def apply_filters(self, request, applicable_filters):
    if 'custom' in applicable_filters:
        custom = applicable_filters.pop('custom')
    else:
        custom = None

    semi_filtered = super(BusinessResource, self).apply_filters(request, applicable_filters)

    return semi_filtered.filter(custom) if custom else semi_filtered

Because you are using Q objects, the standard apply_filters method is not smart enough to apply your custom filter key (since there is none), however you can quickly override it and add a special filter called “custom”. In doing so your build_filters can find an appropriate filter, construct what it means and pass it as custom to apply_filters which will simply apply it directly rather than trying to unpack its value from a dictionary as an item.

More Related Contents:

  1. How to dynamically compose an OR query filter in Django?
  2. How can I login to django using tastypie
  3. How to combine multiple querysets in Django?
  4. Django-tastypie: Any example on file upload in POST?
  5. Django Tastypie: How to Authenticate with API Key
  6. Does the django-rest-framework provide an admin site to manage models?
  7. Django dynamic model fields
  8. How to convert JSON data into a Python object?
  9. Django filter queryset __in for *every* item in list
  10. Django, creating a custom 500/404 error page
  11. How do I force Django to ignore any caches and reload data?
  12. Django: Adding “NULLS LAST” to query
  13. Serving dynamically generated ZIP archives in Django
  14. How can I save my secret keys and password securely in my version control system?
  15. get request data in Django form
  16. many-to-many in list display django
  17. How to filter (or replace) unicode characters that would take more than 3 bytes in UTF-8?
  18. Calling a REST API from django view
  19. Django – makemigrations – No changes detected
  20. Django Rest Framework – How to add custom field in ModelSerializer
  21. DateTimeField doesn’t show in admin system
  22. Django 1.11 TypeError context must be a dict rather than Context
  23. How do I filter values in a Django form using ModelForm?
  24. Django cannot import login from django.contrib.auth.views
  25. Django ConnectionAbortedError: [WinError 10053] An established connection was aborted by the software in your host machine
  26. Django Unhandled Exception
  27. Set Django’s FileField to an existing file
  28. How to Copy/Clone a Virtual Environment from Server to Local Machine
  29. Django: Serving Media Behind Custom URL
  30. How to annotate Count with a condition in a Django queryset

Leave a Comment