REST Calls to Filter Based On Greater Than, Less Than, or Range

[Foobar]

Has anyone successfully used DRF to make API calls using gte, lte, and range? If so, what extension did you use? I've tried django-filters and django-rest-framework-filters but neither work as stated. If someone can share their code that would be much appreciated. Thanks.

[Alan Crosswell]

Take a look at https://github.com/columbia-it/django-jsonapi-training/blob/master/myapp/views.py#L142-L161

On Thu, Jan 3, 2019 at 5:57 PM Foobar <asadh...@gmail.com> wrote:

Has anyone successfully used DRF to make API calls using gte, lte, and range? If so, what extension did you use? I've tried django-filters and django-rest-framework-filters but neither work as stated. If someone can share their code that would be much appreciated. Thanks.

--
You received this message because you are subscribed to the Google Groups "Django REST framework" group.
To unsubscribe from this group and stop receiving emails from it, send an email to django-rest-fram...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

Alan Crosswell

Associate VP & CTO

[Asad Habib]

Alan, thanks. I've gotten it to work now. Is there a way to replace the __ (double underscore) with a single underscore when applying a filter to a field? For example, instead of 

score__range=x,y 

I would like to use 

score_range=x,y

so the Django REST URL is more user friendly. Thanks.

[Olivier DUVAL]

I've coded a generic filter for this operations, it's working with date, number, string or list 

Take a look at https://gist.github.com/zorky/47e808146b6dc00f1e09335b03418344 

For example, URL is like : https://domain.ntld/api/view/?field_operator=threshold||number||lte||30 : filtering threshold field wich is <= 30

you can accumulate filters, ie : https://domain.ntld/api/view/?field_operator=threshold||number||lte||30&field_operator=date_created||date||eq||2019-04-01 : filtering threshlod <= 30 and date_created = 2019-04-01

[Jason]

I've tried django-filters and django-rest-framework-filters but neither work as stated

what do you mean by this?   

[Alan Crosswell]

Double is what Django uses to indicate a relationship rather than just an underscore that is part of a field_name. You can make a custom field name that is what the client uses as in my example but the actual ORM reference has to use double. 

[Alan Crosswell]

Specific example here where the DRF client uses "name" but the actual ORM relationship path is "course_terms__instructor__person__name".

[Gonzalo Amadio]

Can you give code why they don't work?

Error messages, debug code?

El sáb., 5 ene. 2019 0:07, Jason <jjohn...@gmail.com> escribió:

I've tried django-filters and django-rest-framework-filters but neither work as stated

what do you mean by this?   

--