public function executeList () { $this->processSort(); $this->processFilters(); $this->filters = $this->getUser()->getAttributeHolder()->getAll('sf_admin/member/filters'); $this->pager = new sfDoctrinePager('Member', 25); $subprograms = $this->getUser()->getAttribute('subprograms', array()); $this->addSortCriteria($this->pager->getQuery()); $this->addFiltersCriteria($this->pager->getQuery() ->from('Member m left join m.SubProgram s where s.reseller_id = 2') ); $this->pager->setPage($this->getRequestParameter('page', $this->getUser()->getAttribute('page', 1, 'sf_admin/member'))); $this->pager->init(); // Save page if ($this->getRequestParameter('page')) { $this->getUser()->setAttribute('page', $this->getRequestParameter('page'), 'sf_admin/member'); } }