getBackendPremiumListQuery example

// order data         $order = (array) $this->Request()->getParam('sort', []);

        // If a search-filter is set         if ($this->Request()->get('filter')) {
            // Get the value itself             $filter = $this->Request()->get('filter');
            $filter = $filter[\count($filter) - 1];
            $filterValue = $filter['value'];

            $query = $repository->getBackendPremiumListQuery($start, $limit, $order, $filterValue);
            $totalResult = $this->get('models')->getQueryCount($query);
        } else {
            $query = $repository->getBackendPremiumListQuery($start, $limit, $order);
            $totalResult = $this->get('models')->getQueryCount($query);
        }

        try {
            $data = $query->getArrayResult();

            $this->View()->assign(['success' => true, 'data' => $data, 'total' => $totalResult]);
        } catch (Exception $e) {