Message of the day:
Welcome. Latest release: https://www.silverstripe.org/download Community Forum: https://forum.silverstripe.org Features: https://forum.silverstripe.org/c/feature-ideas Archive: https://slackarchive.silverstripe.org
If you have any SilverStripe related questions, please supply the version of Framework you're using.
Did you flush? 🚽 =
Archive temporarily at https://archive.codingplayground.nl (redirect)
I’ll spend 5 minutes googling a subselect and if I don’t find anything,
has_one Year it is 😛
So that could take a pounding... don't want lots of loops or subqueries really
Indeed it is…
Especially if this is a front-end function (eg. filtering parts by model year)
You might even be better off maintaining a table of model years
Well, that's messy then!
Vehicle 1: 1990 - 1992 Vehicle 2: 2000 - 2001
Dropdown needs: 1990, 1991, 1992, 2000, 2001
But won't that be a dropdown from e.g. 1980 to 2020 anyway after some records?