Datatable in Pentaho CDE
Datatable in Pentaho CDE
Hello, im trying to do datatables in pentaho cde. In pentaho the name of component is Table Component.
The problems is where i try to do a dynamic query with a no specific number of columns, and the following error occurs "DataTables warning (table id = 'datosTable'): Added data (size 5) does not match known number of columns (3)".
I have already seen that exist others post with that problem, i havent found a solution for my problem, also i must say that i have little idea.
I try parsing the mysql result, that is a array, in a json and assing it to the datatable, but not works. I have tested all functions of datatable (fnDraw, fnUpdate, fnClearTable,....) but nothing works.
The pluging version is 1.7.4.
Can someone help me?
Thanks.
The problems is where i try to do a dynamic query with a no specific number of columns, and the following error occurs "DataTables warning (table id = 'datosTable'): Added data (size 5) does not match known number of columns (3)".
I have already seen that exist others post with that problem, i havent found a solution for my problem, also i must say that i have little idea.
I try parsing the mysql result, that is a array, in a json and assing it to the datatable, but not works. I have tested all functions of datatable (fnDraw, fnUpdate, fnClearTable,....) but nothing works.
The pluging version is 1.7.4.
Can someone help me?
Thanks.
This discussion has been closed.