SetMaxResult

[HrjSnz]

Hello,

can you help me please ?

I need make query for only first 30 results. But i can not figure how get it.. here is code.. where and andWhere works fine.. But no with setMaxResults etc. Is there way how get it ? Thank you :)

        $datatable = $this->datatableFactory->create(WelcomeDxDatatable::class);
        $datatable->buildDatatable();
        $responseService = $this->datatableResponse;
        $responseService->setDatatable($datatable);
        
        $datatableQueryBuilder = $responseService->getDatatableQueryBuilder();
        $qb = $datatableQueryBuilder->getQb();
        $qb->where('diary.isDxSsb = 1');
        
        return $responseService->getResponse();

[Eloar]

@HrjSnz When preparing response for Datatable You may access QueryBuilder underneath and setup it:

//...
$datatableQueryBuilder = $responseService->getDatatableQueryBuilder();
$qb = $datatableQueryBuilder->getQb();
$qb->where('diary.isDxSsb = 1');
$qb->setMaxResults(30);

return $responseService->getResponse();