How to fetch Elements with a complex DB query? E.g. with some nested AND/OR conditions or just apply two conditions to one field?
For example my Elements have a field
eventDate. I want to fetch all Elements where
NULL or equals "1900-01-01".
The standard way to build Element Criteria is:
$criteria = craft()->elements->getCriteria(ElementType::Entry); $criteria->eventDate = '=...'; $models = $criteria->find();
It doesn't provide an ability to apply several conditions for same field. Is it possible at all without assembling huge queries manually?