we are developing a website with SS 3 and selfwritten DataObjects. One of them holds two dates, marking a start date and an end date for events. Somehow, we need to filter the whole set of DataObjects to receive all currently active eventy (such that start date < current date < end date). The given filter() function can only compare using equality, but not ranges... Is the only way to solve this using completely a selfwritten query?
i don't know if you mean filtering on backend or frontend. For the ModelAdmin in BE this will maybe a good start to look at: http://www.leftandmain.com/silverstripe-tutorials/2011/03/15/taming-the-beast-remodeling-modeladmin-part-2/. But keep in mind this is for ModelAdmin for SS2. Good luck…
PS:Grüße aus Leipzig.