Filter a date field by year or month

[raphodn]

Hi !

I have a date field, and I can already filter using a basic ?date=2024-06-30

I would like to be able to filter by year and month, for instance :

?date__year=2024
?date__year=2024&date__month=06

(similar to what is possible with the Django ORM)

Thanks in advance !

[raphodn]

Similarly to #556, I ended up patching it directly in my code with :

• adding date__year: Optional[str] | None = None in my filter class
• and having a custom filter in the crud

  if filters.date__year:
  query = query.filter(extract("year", Price.date) == filters.date__year)
  filters.date__year = None

see this PR changes : https://github.com/openfoodfacts/open-prices/pull/350/files

[github-actions[bot]]

This issue is stale because it has been open 60 days with no activity. Remove stale label or comment or this will be closed in 5 days.