public function testBasic() { $this->assertInstanceOf('Zend\\Db\\Sql\\Select', $this->filterSelect->getSelect()); $this->assertInstanceOf('Zend\\Db\\Sql\\Sql', $this->filterSelect->getSql()); // Test two filters $filter = new \ZfcDatagrid\Filter(); $filter->setFromColumn($this->column, '~myValue,123'); $filter2 = new \ZfcDatagrid\Filter(); $filter2->setFromColumn($this->column2, '~myValue,123'); $filterSelect = clone $this->filterSelect; $filterSelect->applyFilter($filter); $filterSelect->applyFilter($filter2); $select = $filterSelect->getSelect(); /* @var $where \Zend\Db\Sql\Where */ $where = $select->getRawState('where'); $predicates = $where->getPredicates(); $this->assertEquals(2, count($predicates)); }