Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions /

Filtering a DataObjectSet by range query?


Reply


2 Posts   755 Views

Avatar
NicoHaase

Community Member, 6 Posts

24 March 2012 at 4:20am

Hi,
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?
Sunny greetings
Nico

Avatar
Pipifix

Community Member, 54 Posts

10 April 2012 at 8:56pm

Hi Nico,

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…

Pipifix.

PS:Grüße aus Leipzig.