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 /

Filter LessThanOrEqual and GreaterThanOrEqual don't work (SS 3.1.2)


Reply


3 Posts   1044 Views

Avatar
Stephan

Community Member, 55 Posts

14 January 2014 at 6:42am

Hi experts,
I have created a news module to show articles on my website.
I want to show only news which are between my start- and end-date.
So I created:

$news = NewsArticle::get()->filter(array(
   'StartDate:LessThanOrEqual' => date('Y-m-d'),
   'EndDate:GreaterThanOrEqual' => date('Y-m-d')
   ))->sort(array('Date' =>'DESC'));


which doesn't work.
Silverstripe debug says:

[User Error] Uncaught InvalidArgumentException: ExactMatchFilter does not accept LessThanOrEqual as modifiers
GET /index.php/de/aktuelles/?showqueries=1
Line 20 in /Applications/XAMPP/xamppfiles/htdocs/framework/search/filters/ExactMatchFilter.php
Why is Silverstripe using the ExactMatchFilter ?

However

$news = NewsArticle::get()->filter(array(
   'StartDate:LessThan' => date('Y-m-d'),
   'EndDate:GreaterThan' => date('Y-m-d')
   ))->sort(array('Date' =>'DESC'));


works fine!
But doesn't give me the articles I do need.

Running SS 3.1.2

TIA Stephan

Avatar
simon_w

Forum Moderator, 474 Posts

14 January 2014 at 8:42am

These were added to 3.1 after 3.1.2 was released, so they'll be in 3.1.3. Until then, you can do the opposite of what you're after to get the same result.

That is, filter('Field:LessThanOrEqual', value) becomes exclude('Field:GreaterThan' value). Likewise for GreaterThanOrEqual.

Avatar
Stephan

Community Member, 55 Posts

14 January 2014 at 10:23am

Edited: 14/01/2014 10:28am

Ok, thanks for the info.

So tried:

$news = NewsArticle::get()->exclude(array(
   'StartDate:GreaterThan' => date('Y-m-d'),
   'EndDate:LessThan' => date('Y-m-d')
   ))->sort(array('Date' =>'DESC'));

But SilverStripe is fooling me,
instead of making

WHERE NOT(("NewsArticle_Live"."StartDate" > '2014-01-13') OR ("NewsArticle_Live"."EndDate" < '2014-01-13'))

the following SQL Query is generated:

WHERE (("NewsArticle_Live"."StartDate" <= '2014-01-13') OR ("NewsArticle_Live"."EndDate" >= '2014-01-13'))

this is wrong.

So I changed my code to

$news = NewsArticle::get()->filter(array(
   'StartDate:GreaterThan:Not' => date('Y-m-d'),
   'EndDate:LessThan:Not' => date('Y-m-d')
   ))->sort(array('Date' =>'DESC'));

which makes the following nice SQL Query:

("NewsArticle_Live"."StartDate" <= '2014-01-13') AND ("NewsArticle_Live"."EndDate" >= '2014-01-13')