CSV Export

Hey Gaetano S.

The createListQueryBuilder is not a Doctrine method, it's a EasyAdmin method which creates the query builder for the "List" view. I believe the new name for that method is createIndexQueryBuilder()

Cheers!

Well,
it is not so easy for me to understand this method. I mean, I'm not sure about the parameters to pass it. This is my use case:

• a service csvExport as mentioned in the tutorial
• a StudyCrudController for my entity Study
• an entity ResultStudy (relation ManyToOne with Study, inversed by studyResult)

I would like to create a custom button on EDIT page on StudyCrudController to extract a CSV with the data of ResultStudy, so I added this code for my button:
`
public function configureActions(Actions $actions): Actions

{

$exportCSV = Action::new('export', 'Export CSV', 'fa fa-file-export')
->setLabel('field.export')
->addCssClass('btn btn-primary')
->linkToCrudAction('exportAction');

return $actions
  ->add(Crud::PAGE_EDIT, $exportCSV)
;
}

public function exportAction(AdminContext $adminContext, csvExporter $exporter

{
$sortDirection = $adminContext->getRequest()->query->get('sortDirection');
if (empty($sortDirection) || !in_array(strtoupper($sortDirection), ['ASC', 'DESC'])) {

  $sortDirection = 'DESC';

}
// here for this method you mentioned, the parameters are not the same (SearchDto $searchDto, EntityDto $entityDto, FieldCollection $fields, FilterCollection $filters)

// What do I put?
$queryBuilder = $this->createIndexQueryBuilder(

?????,
?????,
?????,
?????
);

return $exporter->getResponseFromQueryBuilder(

 $queryBuilder,
 ResultStudy::class,
 'resultStudy.csv'
);
}

`

Thank you so much for your help

Seems like things have changed even more than I expected but you can see an example of how to call the createIndexQueryBuilder() method https://github.com/EasyCorp/EasyAdminBundle/blob/master/src/Controller/AbstractCrudController.php#L116
the key is on using the AdminContext $context argument

Ok, thanks for the example. I'll try.

Thanks, I will try it.

You can use:
$this->filterQueryBuilder($queryBuilder);

Hey Brent

I think what you can do is to override the createQueryBuilder() method of your export CSV action and add the same filters you are applying to the list view. Does it makes sense?

Cheers!

Hey Khaoula A.

That's strange :)
When you do this call inside your controller's action

        $queryBuilder = $this->createListQueryBuilder(
            $this->entity['class'],
            $sortDirection,
            $this->request->query->get('sortField'),
            $this->entity['list']['dql_filter']
        );

The $queryBuilder is set to null?

I will need to see how you are creating it

Cheers!

Hey Remy J.

It depends on what you want to achieve but probably you could implement your own way of generating columns by using the PropertyAccess component or maybe even the Serializer component.

Cheers!

Hey Kaizoku

Thanks for sharing your findings, as you can see there are too many ways of doing things in EasyAdminBundle :)

Cheers!