DateRange: Unable to select larger range after making a selection & auto end-range decrement - Githubissues

evidence-dev / evidence

Business intelligence as code: build fast, interactive data visualizations in pure SQL and markdown

https://evidence.dev

MIT License

3.44k stars 167 forks source link

DateRange: Unable to select larger range after making a selection & auto end-range decrement #1892

Open AyushAgrawal-A2 opened 1 month ago

AyushAgrawal-A2 commented 1 month ago

Steps To Reproduce

Using following query in example-project

Environment

Node version (node -v): 18.20.2
npm version (npm -v): 10.5.0
OS: Windows 11 x64
Browser: Chrome 123.0.6312.122
Database: example-project's needful_things.orders

Expected Behavior

End range date should not auto decrement
I should to able to select a larger date range, irrespective of previous selection

Actual Behaviour

End range auto decrements (this is locale specific, error in dateToYYYYMMDD function for some locale, mine is UTC+5:30)

https://github.com/evidence-dev/evidence/assets/54364088/ee846730-4be2-4ce3-a2cc-87eea38c51f7

Only the selected range is active, unable to select outside of previous selection (screencast after fixing date autodecrement issue)

https://github.com/evidence-dev/evidence/assets/54364088/f4d17ae3-e08c-43ee-8311-3d95ce5ff607

Workarounds

Use a secondary query that is not filtered by the daterange, to drive the daterange (same as #1875 )