search

zazuko / amos

Archiv Museum ohne Schliesszeiten
1 stars 0 forks source link

Change histogram filtering behaviour for records with intervals as creation dates #54

Closed PlekszyGladz closed 1 year ago

PlekszyGladz commented 2 years ago

Currently filtering dates seems to only select records where both the start and the end date are inside the specified interval.

As we have mandy records with large creation date intervals filtered results should include all records with any overlap to the filter. That is (start OR end date inside query interval ) OR (start date smaller than the query interval AND end date lager than the query interval)

l00mi commented 2 years ago

The histogram is now only filtering on the Start date.

PlekszyGladz commented 2 years ago

@l00mi Just checked it and seems to work fine. But only filtering the Start Date still leaves out some cases. I made a small sketch showing a query (pink) and possible records below them (designated as A to F) image Cases A to D should show up in the results. With the current setup we only have B and D. --> It seems the simplest ist to rule out all records where their end date is lower than the query start date or the start date is higher than the query end date. What do you think?