Enhance year overview date query

[filiptypjeu]

On the year overview page you can find a summary of everything that happened a specific year. The problem is that for functionaries and groups, only the year of the start date is checked.

Say we want to look at year 2000, then these relevant date intervals will not be included (but they should):

• 1.1.1999 - 31.12.2000
• 1.1.1999 - 31.12.2001
• 1.5.1999 - 31.4.2000

I'm guessing some 'start_year <= year <= end_year' query could solve the issue.

[filiptypjeu]

start_year <= year && end_year => year is the correct filter, but I'm not sure how to implement that in the queries for the 'all years' view.