I need to create a list in sonata admin but it's not related to an entity, i want to know if it's possible to use the sonata admin class to show the list of my data with pagination, filters ...
i tried to ovveride the createQuery method but didn't succeeded, i need left join a union query result in my query which i did'nt succeed to add to the queryBuilder and if i use the NativeQuery i can't bind it to ProxyQuery what this method should return
$query = parent::createQuery($context);
$qb = $query->getQueryBuilder();
$rootAlias = $qb->getRootAlias();
$qb->leftJoin($rootAlias.'.champs', 'ch')
->leftJoin('ch.valeur','v');
// here i need to left join union result
// something like ->leftJoin('select val from f1 union select val from f2 ...','val');