You can check the value returned by the "datatableClientes" controller method. Do something like these:

public function datatableClientes() {

        $todos = DB::table('crm_cliente AS c')
                                   ->select('c.tipo','c.nome_fantasia','c.razao_social','c.numero_funcionarios')
                   ->where('c.cod_categoria','=', '1');

        $retorno = Datatables::of($todos, true)         
                           ->add_column('ver', 'See Image')
                           ->add_column('editar', 'Edit Image')
                           ->add_column('apagar', 'Delete Image')                       
                           ->make();
        dd($retorno);

        return $retorno;

    }

To see the results, you'll need to acces de route direct from the browser (domain.com/clientes/datatable-clientes). The page will dump de content of the return, wich is expected to be a valid JSON.

If everything is ok, the problem probaly is in your JS script...

I make the test and the return was this:

Array ( [0] => datatable-clientes )

Should be a JSON, right?

Why don't you use regular html tables where you have full control over everything? I would never ever ever use a third party table gen, because I know php and html, and css.

I liked the plugin and his functions (pagination, filter, column reorder...), so I want to use it in my app.

I just want help to resolve this problem.

destrutorx said:

I make the test and the return was this:

Array ( [0] => datatable-clientes )

Should be a JSON, right?

Default collections (returned by Eloquent, for example) in Laravel are automatically converted to JSON when returned from controller/route. Blim package, as far I can see, should return JSON to... But looking at your response, it returned an array instead.

Try to make this test again, but now dump de query result (don't forget to add "->get()" to it). It should return a JSON. If yes, probably is some error with Blim package. In this case, you'll need to read the documentation to understand why.