Complex lookups with Django models about django-url-filter HOT 2 OPEN

I'd upvote this for implementation. Can't imagine it's too hard, though may need to support a slightly richer URL syntax. Currently:

http://site.tld/model?field1=val1&field2_lt=val&field3_gt=val3

is all AND logic. To support OR logic we could introduce a new syntax. Just floating an idea it could be as simple as introducing some new URL parameters, like and and or

http://site.tld/model?field1=val1&and&field2_lt=val2&or&field3_gt=val3

That's possible because order exists on the URL and I'd moot that such a string would be parsed right to producing:

Q(field1=val1) & (Q(field2_lt=val2) | Q(field3_gt=val3) )

Of course for true generality we'd need to be able to group items on the URL, but by same reasoning, two parameters, lb and rb perhaps can encode braces.

Alternately the whole thing can be encoded in one parameter "filter" with one of the very few URL friendly chars as a delimiter:

http://site.tld/model?filter=lb~field1~val1~and~field2_lt~val2~rb~or~field3_gt=val3

might parse to:

(Q(field1=val1) & Q(field2_lt=val2)) | Q(field3_gt=val3)

Anyhow, I think supporting OR logic on the URL would be a major value add to django-url-filter.

Just my thoughts anyhow.

from django-url-filter.

currently thats not possible out of the box. but you can do custom filters via callable filters - https://django-url-filter.readthedocs.io/en/latest/api/url_filter.filters.html#url_filter.filters.CallableFilter

from django-url-filter.