How to get more than 1000 rows in qHypercube -> qDataPages

[rohanas1701]

Hi All,

I am trying to build a button extension to get excel export of multiple tables into single excel using object ID's.

I am taking input as ObjectID, and in backend JS using below code to create a qlik Table object -

var app =  qlik.openApp( appName, config);
app.getObject("QV01",objIdE).then( function( object ) {

var qTable = qlik.table(object);

console.log(qTable);

}

On the console, when I traverts to qDataPages , I can able to see 1000 rows of data there ,but My table is having more than 1000 records.

qSize is giving me correct size i.e qSize: {qcx: 2, qcy: 1647}

I searched about it and find few recommendations to adjust the InitialProperties . I have given qWidth :4 and qHeight 2500 there, still no luck.

And Secondly , if I try to implement it with backendAPI functions mentioned in documentation, i am not able to associate proper this reference , because the main object is Button and not the table.

Please help how can I get more than 1000 rows. 

[vincent_ardiet_]

There is a limit of 10.000 cells, you will need to paginate, see https://help.qlik.com/en-US/sense-developer/August2023/Subsystems/APIs/Content/Sense_ClientAPIs/Capa...

[rohanas1701]

Could you please help with sample code. The documentation is not very explanatory.

[ajaykakkar93]

Hi,

Please follow the below link.

https://qlik.dev/extend/build-extension/get-additional-data

[rohanas1701]

Hi Ajay,

I tried this method, but it only works if my extension object itself is a table (self). 

In my case, i am building a button which passes the list of table object id's and with that , it fetches the records. Hence ,there i cant use self.backendApi (bcoz in my case, self is button and not table)

[Adam_Romanowski]

If you change InitialProperties in extension already placed on the sheet, you must "replace" old visualization with updated extension - even if it's the same name.

So in edit mode drag your extension with updated InitialProperties and drop on already placed visualization on the sheet.

[ajaykakkar93]

Ok, Tell me your entire usecase, this isn't the full usecase. i may be able to help you