KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Dashboard: Procedure and table page size #2323

Closed Andre Van Der Walt opened this topic on on Sep 7, 2021 - 2 comments

Andre Van Der Walt commented on Sep 7, 2021

Hi,

Please assist, the following seems to be a bug. When using the new procedure call, the pageSize() is not applied to the table and all records are displayed in 1 page.

class TestTable extends Table
{
    protected function onCreated()
        {
            $this->pageSize(10)
            ->tableHover(true);
        }

    protected function dataSource()
    {
    ...

    $query = AutoMaker::procedure()->call(
            "example",[
                1,
                $param1,
                $param2,
                $param3
            ]
        );
        return $query;
    }
}

When we test without using AutoMaker, pageSize() is working as expected:

$query = DB::select("CALL example(
            1,
            '".$param1."',
            '".$param2."',
            '".$param3."'
            );
        ");


KoolReport commented on Sep 8, 2021

Thank you very much for letting us know. I will forward your post to our dev.team for further investigating. For now, if you try this, does it work?

    $query = AutoMaker::procedure()->call(
            "example",[
                1,
                $param1,
                $param2,
                $param3
            ]
        );
        return $query->run(); //<---Add run() method
Andre Van Der Walt commented on Sep 8, 2021

Working thank you!

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
bug
solved

Dashboard