BETWEEN operator in CQL2 filter returns 400 Bad Request

[YuriZmytrakov]

Describe the bug
BETWEEN operator in CQL2 filters (isBetweenPredicate) does not work. When used in a query, the API returns 400 Bad Request. Other comparison operators like >= and <= work correctly.

To Reproduce

1. Send GET request to:
   /collections/sentinel-2-l2a/items?filter=properties.eo:cloud_cover%20BETWEEN%200%20AND%2050&filter-lang=cql2-text&fields=id,properties.eo:cloud_cover&limit=100

2. The API returns HTTP 400 instead of valid results. Replace BETWEEN with >= and <= (e.g. filter=properties.eo:cloud_cover>=0 AND properties.eo:cloud_cover<=50) this works as expected

[jonhealy1]

Hi @YuriZmytrakov. Does BETWEEN work on the /collections route like ie. /collections?filter=

[jonhealy1]

Reopen if needed

[YuriZmytrakov]

Hi @YuriZmytrakov. Does BETWEEN work on the /collections route like ie. /collections?filter=

@jonhealy1 yes it does work with collections, just tested with interval value, and clause BETWEEN filtered out the collections. The priority would be to add BETWEEN to items.

[jonhealy1]

Hi @YuriZmytrakov this should be fixed now for Items.

[YuriZmytrakov]

Resolved, thank you @jonhealy1 !