https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Extension-Get-all-data-for-field/m-p/1729302#M13041 <P>The limitation of 10000 cells is for each getHyperCubeData call, so building up a page array will not help you. You need to make multiple calls &nbsp;instead. But should you really do this? What happens &nbsp;if there are millions of rows?</P> Mon, 20 Jul 2020 17:10:33 GMT ErikWetterberg 2020-07-20T17:10:33Z https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Extension-Get-all-data-for-field/m-p/1676159#M12348 <P>Hello again guys!<BR /><BR />My quest on building an extension for advanced filters continues. Now I want to get all data by field.</P><P>For now, my code looks like this:</P><LI-CODE lang="javascript">const getDataByField = function (app, fieldName) { return new Promise((resolve, reject) =&gt; { // We'll create a table, which we'll then take hypercube data from var table = app.createTable([fieldName], [], {}); table.OnData.bind(function () { // Create an array of pages to retrieve var pageArray = []; for (let i = 0; i &lt; 1; i++) { pageArray.push({qTop: 10000 * i, qLeft: 0, qWidth: 1, qHeight: 10000 * (i + 1) - 1}); } // Set up the main retrieve table.model.getHyperCubeData('/qHyperCubeDef', pageArray).then(function (data) { let rows = data[0].qMatrix; var outputList = []; rows.forEach(function (row) { outputList.push(row[0].qText); }); // Kill the imaginary table table.OnData.unbind(); app.destroySessionObject(table.model.id); resolve(outputList); }) }) }) };</LI-CODE><P>But I'm limited to 10k rows. It looks like&nbsp;<A href="https://help.qlik.com/en-US/sense-developer/November2019/Subsystems/APIs/Content/Sense_ClientAPIs/CapabilityAPIs/FieldAPI/getMoreData-method.htm#anchor-4" target="_self">qlik.app.field.getMoreData()</A> might be what I'm looking for, but the docs have zero info <span class="lia-unicode-emoji" title=":crying_face:">😢</span></P><P>Any tips?</P> Sat, 16 Nov 2024 03:15:11 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Extension-Get-all-data-for-field/m-p/1676159#M12348 savandriy 2024-11-16T03:15:11Z https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Extension-Get-all-data-for-field/m-p/1728098#M13021 <P>Does anyone have any idea how to achieve this? The question is still relevant <span class="lia-unicode-emoji" title=":folded_hands:">🙏</span></P> Wed, 15 Jul 2020 15:01:01 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Extension-Get-all-data-for-field/m-p/1728098#M13021 savandriy 2020-07-15T15:01:01Z https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Extension-Get-all-data-for-field/m-p/1729302#M13041 <P>The limitation of 10000 cells is for each getHyperCubeData call, so building up a page array will not help you. You need to make multiple calls &nbsp;instead. But should you really do this? What happens &nbsp;if there are millions of rows?</P> Mon, 20 Jul 2020 17:10:33 GMT https://community.qlik.com/t5/Integration-Extension-APIs/Qlik-Extension-Get-all-data-for-field/m-p/1729302#M13041 ErikWetterberg 2020-07-20T17:10:33Z