CRUDlex\MySQLData::listEntries PHP Method

    public function listEntries(array $filter = [], array $filterOperators = [], $skip = null, $amount = null, $sortField = null, $sortAscending = null)
    {
        $fieldNames = $this->definition->getFieldNames();
        $queryBuilder = $this->database->createQueryBuilder();
        $table = $this->definition->getTable();
        $queryBuilder->select('`' . implode('`,`', $fieldNames) . '`')->from('`' . $table . '`', '`' . $table . '`')->where('deleted_at IS NULL');
        $this->addFilter($queryBuilder, $filter, $filterOperators);
        $this->addPagination($queryBuilder, $skip, $amount);
        $this->addSort($queryBuilder, $sortField, $sortAscending);
        $queryResult = $queryBuilder->execute();
        $rows = $queryResult->fetchAll(\PDO::FETCH_ASSOC);
        $rows = $this->enrichWithMany($rows);
        $entities = [];
        foreach ($rows as $row) {
            $entities[] = $this->hydrate($row);
        }
        return $entities;
    }