public function getFilteredPaginatedList(&$columns, &$filter, $pagination, $order = null)
 {
     parent::getFilteredPaginatedList();
     $columnsSQL = $columns ? implode(', ', array_keys($columns)) : null;
     $whereSQL = $this->whereSQLForFilter($filter) . ' AND userState != \'deleted\'';
     $orderBySQL = $this->orderSQL($columns, $order);
     $offset = null;
     $limit = null;
     if ($pagination->getType() == 'Standard') {
         $offset = $pagination->getCurrentOffset();
         $limit = $pagination->getMaxRecordsOnPage();
     }
     return $this->getListBySQLParams($columnsSQL, $whereSQL, $orderBySQL, $offset, $limit);
 }
 public function getFilteredPaginatedList(&$columns, &$filter, $pagination, $order = null)
 {
     $cols = array('adminState' => null) + $columns;
     return parent::getFilteredPaginatedList($cols, $filter, $pagination);
 }