Hi,

Is there a way to have PivotTable (KWidget) working with procedure? The below code raise an error.

$query = DB::select("
            CALL `get_results`
                (
                1,
                '".$param1."',
                '".$param2."'
                )
        ");
->run()
            ->process(
                ColumnMeta::process([
                    'column1'=>[
                        'type' => 'number',
                    ],
                    'column2'=>[
                        'type' => 'number',
                        'suffix'=> '%'
                    ],
                ])
                    ->pipe(
                    Pivot::process([
                        'dimensions'=>array(
                            'row'=>'column1'
                        ),
                        'aggregates'=>array(
                            'sum'=>'column2',
                        )
                    ])
                )
            );
        return $query;

Thank you

This do not work

AutoMaker::rawSQL("
    your procedure here
")