3060 Posts in 864 Topics by 646 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 348 Views |
-
DataList filter using OR
14 November 2012 at 8:12am
I need assistance on how to filter a datalist by where Firstname = 'Sam' or surname = 'paul'. How do you achieve this using the new ORM?
-
Re: DataList filter using OR
19 November 2012 at 12:04am
Hi All,
To elaborate on my issueI have a class called students with two fields : Firstname and Surname. I want A datalist of students with either Firstname Samuel or Surname 'Paul'. How do you achieve this with the new ORM?
-
Re: DataList filter using OR
19 November 2012 at 1:34am
Hi,
I think you can still use where() as in:$students = Student::get()->where("Firstname = 'Samuel' OR Surname = 'Samuel'");
-
Re: DataList filter using OR
19 November 2012 at 2:44am
Thanks martimiz,
It seems like filter method cannot be used to achieve this. -
Re: DataList filter using OR
19 November 2012 at 4:09am Last edited: 19 November 2012 4:10am
Maybe you could even:
$students = Student::get()->exclude(array('Firstname:not' => 'Samuel', 'Surname:not' => 'Paul'));
That would be the other way around, wouldn't it? But I've not tested this and also it feels a bit strange and unreadable...
So maybe we just missed something
-
Re: DataList filter using OR
20 November 2012 at 10:07pm
$students = Student::get()->filter('Firstname', array('Samuel', 'Paul'));
-
Re: DataList filter using OR
20 November 2012 at 11:42pm
kinglozzer
I think yours is for a result set for where firstname is either paul or samuel. My question was for where firstname is samuel or surname is paul. I implemented martimiz first ansewer and it was okay.
| 348 Views | ||
|
Page:
1
|
Go to Top |
