Sorting, filters, pagination didn't work( Please Help!

[AlexLihuto]

This is my DataTableType

class AdminsDataTableType extends AbstractDataTableType
{
    private ManagerRegistry $doctrine;
    private UrlGeneratorInterface $urlGenerator;

    public function __construct(
        private readonly TranslatorInterface $translator,
        UrlGeneratorInterface $urlGenerator,
        private readonly Security $security,
        ManagerRegistry                      $doctrine,
    ) {
        $this->urlGenerator = $urlGenerator;
        $this->doctrine = $doctrine;
    }

    public function buildDataTable(DataTableBuilderInterface $builder, array $options): void
    {
        $builder
            ->addFilter(DataTableBuilderInterface::SEARCH_FILTER_NAME, SearchFilterType::class, [
                'default_operator' => Operator::Contains,
                'handler' => function (ProxyQueryInterface $query, string $search): void {
                    $searchTerm = '%' . $search . '%';

                    $query->andWhere('admin_users.email LIKE :search')
                        ->setParameter('search', $searchTerm);
                },
            ])
            ->addFilter('admin_group', NumericFilterType::class, [
                'label' => $this->translator->trans('admin_group'),
                'default_operator' => Operator::Equals,
                'form_type' => ChoiceType::class,
                'form_options' => [
                    'choices' => array_diff_key(AdminGroup::getAllLangForFilter('admin_group', $this->translator), array_flip([AdminGroup::Root->value])),
                ],
            ])
            ->addFilter('role_id', EntityFilterType::class, [
                'label' => $this->translator->trans('role'),
                'default_operator' => Operator::Equals,
                'form_options' => [
                    'class' => Role::class,
                    'choice_label' => 'name',
                ],
                'active_filter_formatter' => function (FilterData $data) {
                    $value = $data->getValue();

                    if ($value instanceof Role) {
                        return $value->getName();
                    }

                    return $value;
                },
            ])
            ->addColumn('id', TextColumnType::class, [
                'sort' => true,
                'label' => $this->translator->trans('id')
            ])
            ->addColumn('email', TextColumnType::class, [
                'sort' => true,
                'label' => $this->translator->trans('email'),
            ])
            ->addColumn('two_factor', TwoFactorColumnType::class, [
                'sort' => true,
                'label' => '2 FA',
                'template_path' => 'data_table/templates/admins/two_factor_column.html.twig',
            ])
            ->addColumn('admin_group', EnumColumnType::class, [
                'sort' => true,
                'label' => $this->translator->trans('admin_group'),
            ])
            ->addColumn('role', TextColumnType::class, [
                'sort' => true,
                'label' => $this->translator->trans('role'),
                'formatter' => function (Role $role) {
                    return $role->getName();
                }
            ])
            ->addColumn('admin_status', EnumColumnType::class, [
                'sort' => true,
                'label' => $this->translator->trans('admin_status'),
            ])
            ->addColumn('', ActionsColumnType::class, [
                'actions' => [
                    ' ' => [
                        'type' => ButtonActionType::class,
                        'type_options' => [
                            'attr' => [
                                'class' => 'btn btn-link text-info fs-14 lh-1'
                            ],
                            'icon_attr' => [
                                'class' => 'ri-edit-line',
                            ],
                            'href' => function (Admin $admin): string {
                                return $this->urlGenerator->generate('profile', [
                                    'id' => $admin->getId(),
                                ]);
                            },
                        ],
                        'visible' => $this->security->isGranted('edit', 'admins')
                    ],
                    '' => [
                        'type' => ButtonActionType::class,
                        'type_options' => [
                            'attr' => [
                                'class' => 'btn btn-link text-danger fs-14 lh-1'
                            ],
                            'icon_attr' => [
                                'class' => 'ri-delete-bin-5-line',
                            ],
                            'confirmation' => [
                                'label_title' => $this->translator->trans('deletion_confirmation'),
                                'label_description' => $this->translator->trans('are_you_sure'),
                                'label_confirm' => $this->translator->trans('confirm'),
                                'label_cancel' => $this->translator->trans('cancel'),
                                'type' => 'danger',
                            ],
                            'href' => function (Admin $admin): string {
                                return $this->urlGenerator->generate('admin.delete', [
                                    'id' => $admin->getId(),
                                ]);
                            },
                        ],
                        'visible' => $this->security->isGranted('ROLE_ADMIN')
                    ],
                ],
            ]);
    }

    public function configureOptions(OptionsResolver $resolver): void
    {
        $resolver->setDefault('themes', [
            '@KreyuDataTable/themes/bootstrap_5.html.twig',
        ]);
    }
}

method in service that create datatable and pass it to controller

public function index(Request $request)
    {
        $queryBuilder = $this->doctrine->getManager()->getRepository(Admin::class)->listQueryBuilder();

        $dataTable = $this->createDataTable(AdminsDataTableType::class, $queryBuilder);

        $dataTable->handleRequest($request);

        return $dataTable->createView();
    }

All good, but sorting, pagination and filters didn't work(( When i use filtration and dump datatable after handleRequest method, query is good but table didn't render this query

[Kreyu]

Hey @AlexLihuto. Your definition of data table looks fine, a little bit verbose, but nothing that should break. One thing I don't understand is why and how you're returning DataTableView from controller (return $dataTable->createView();) instead of response. I thought that the controller is marked with Symfony Template attribute, but even then, the controller should return an array of context? Do you have something custom made, related with the rendering?

[AlexLihuto]

@Kreyu, thanx for your answer. This is a service method, sorry for bad naming) Here is my controller method:

#[Route('/admin', name: 'admins')]
    public function index(Request $request): Response
    {
        $this->denyAccessUnlessGranted('view', 'admins');

        return $this->render('admins/index.html.twig', [
            'admins' => $this->adminService->index($request),
        ]);
    }
    ```

[Kreyu]

Sorry for the super late response. Based on the snippets you've provided I am unable to help :( If everything in dumps seems fine (for example, the query gets updated properly), then I would double check the rendering, maybe something related with the Turbo?