How can I show more than 50 rows in a Table Widget?

[AguWolkovicz]

I've been working on a Table Widget to customize it's styles and other stuff and it's only showing up to 50 rows for the current selection. When I export its data, I get a spreadsheet with the around 180 rows that the table is supposed to show.

Is this a limitation for the widgets?

Is there a way I can change this?

Is there a way I can paginate or something like that all the data?

Thanks in advance!

[Aiham_Azmeh]

Hi agu440labs‌,

Yes it's a limitation (for now) - we are working on improving widgets.

rbecher‌, managed to find a workaround for it by adding ng-init in the first scope of the widget element -- his code:

<div ng-init="data.model.enigmaModel.applyPatches([{qPath: '/qHyperCubeDef/qInitialDataFetch/0/qWidth', qOp: 'replace', qValue: '20'}])"></div>

Related threads:

• Widgets - Access more than 10 columns x 50 rows of data
• Widget hypercube qwidth can it be adjusted greater than 10

I hope this helps

[AguWolkovicz]

Hi aaz‌,

Actually your solution is useful to increase the number of columns that the HyperCube will contain when looping it within the table; I found that the correct solution for increasing the number of Rows is as follows:

<div ng-init="data.model.enigmaModel.applyPatches([{qPath: '/qHyperCubeDef/qInitialDataFetch/0/qHeight', qOp: 'replace', qValue: '1000'}])"></div>

Regards,

Agu.-

[Aiham_Azmeh]

agu440labs‌,

Yes you're right, since I never tried it myself, I was just showing you his code as an example in order to maybe help you find the solution.

In a widget, you should also be able to get more data with the table API:

<button ng-if="data.rowcount>data.rows.length" qva-activate="data.getMoreData()">More</button>

[rbecher]

Yea, that's why you wouldn't need to patch qHeight because it's not a limit.

[jftalmeida]

Dears,

Has this bug been fixed? Or do you have any workaround?

Thanks.

[tversweyveld]

Hi rbecher‌,

I saw your workaround and I would like to use this technique to change the hyperCube in the widget to a different qMode. I'm trying to do it like this:

<div ng-init='data.model.enigmaModel.applyPatches([{"qPath": "/qHyperCubeDef","qOp": "add","qValue": "\"qMode\": \"K\""}])'></div>

But I get a JSON parse error: Unexpected JSON token error.

Do you have any idea how to fix this?

[rbecher]

Try this:

<div ng-init='data.model.enigmaModel.applyPatches([{"qPath": "/qHyperCubeDef/qMode","qOp": "add","qValue": "\"K\""}])'></div>

[tversweyveld]

Yessssss, thank you so much!!

[andydietler]

Is there any way to do this in the javascript if I'm working on an extension that doesn't have an .html file?