topic Re: Building a JavaScript array by paging through HyperCube pages in AngularJS extension in Integration, Extension & APIs

Building a JavaScript array by paging through HyperCube pages in AngularJS extension

frankpacker_AoD — Fri, 15 Nov 2024 23:42:51 GMT

Hi All,

Hoping for some help with building a big JavaScript object from a HyperCube that goes to more than 10000 cells.

It's a straightforward AngularJS extension, and I've found the article for retrieving extra data here: https://help.qlik.com/en-US/sense-developer/May2021/Subsystems/Extensions/Content/Sense_Extensions/Howtos/get-additional-data.htm

The issue I have is that I don't really want to call my paint function for every page of the HyperCube. What I actually want to do is build a chunky JavaScript array of all the data that I can then operate on to use in my template.

Basically, at the end of the day, I'm trying to work out the best method to loop through all pages of the huge HyperCube in a single execution of paint so that I can modify the structure of the data to suit the needs of the extension.

I've added comments to the code here to better explain what I'm trying to achieve.

define([

"qlik",

"jquery",

"text!./style.css",

"text!./template.html",

], function (qlik, $, cssContent, template) {

"use strict";

$("<style>").html(cssContent).appendTo("head");

return {

template: template,

initialProperties: {

qHyperCubeDef: {

qDimensions: [],

qMeasures: [],

qInitialDataFetch: [

{

qWidth: 20,

qHeight: 500,

definition: {

type: "items",

component: "accordion",

items: {

dimensions: {

uses: "dimensions",

min: 6,

max: 6,

measures: {

uses: "measures",

min: 0,

max: 14,

sorting: {

uses: "sorting",

settings: {

uses: "settings",

support: {

snapshot: true,

export: true,

exportData: true,

paint: function ($element, layout) {

//this block is from the above link

var lastrow = 0, me = this;

var resultTable = [];

this.backendApi.eachDataRow(function (rownum, row) {

lastrow = rownum;

resultTable.push(row); //can push each row into my table and that does work ok, but requires a repaint for every iteration and means that I can't operate on the output table because of the delay in promises returning

});

if (this.backendApi.getRowCount() > lastrow + 1) {

var requestPage = [

{

qTop: lastrow + 1,

qLeft: 0,

qWidth: 20,

qHeight: Math.min(500, this.backendApi.getRowCount() - lastrow),

];

this.backendApi.getData(requestPage).then(function (dataPages) {

me.paint($element);

});

}

console.log("resultTable", resultTable); //I want to wait for the completed dataset (so, wait for the promises to return) when the paint gets called.

controller: ["$scope", function ($scope) {

}],

};

});

Any help would be appreciated!

Re: Building a JavaScript array by paging through HyperCube pages in AngularJS extension

frankpacker_AoD — Wed, 22 Sep 2021 03:37:42 GMT

I've made some progress on this, and think I'm nearly where I need to be with it, but there's still a small problem I hope someone can help me with, or tell me where I'm off track.

This is my paint function, now:

I'm running a loop to build the page requests for each execution of backendApi.getData, pushing the promises into an array then executing them with Promise.all

Logging the array thePromises to the console produces the below, which superficially looks fine:

but the following error is thrown from the Promise.all function call:

Further examination of the promises in the array reveals the cause:

I can confirm that executing just the first promise from the array works ok, like this:

So does executing it twice in an array:

So, something's not working properly in the loop that builds the array, and the second iteration is not receiving the backendApi.getData promise correctly.

Is this an issue with reference typing, or something else to do with my understanding of this particular promis object?

Can anyone help with how to get this last part over the line?

Re: Building a JavaScript array by paging through HyperCube pages in AngularJS extension

frankpacker_AoD — Wed, 22 Sep 2021 06:13:31 GMT

Ok, solved it.

This needs to be set: this.backendApi.setCacheOptions({enabled: false});

The cache option on backendApi means that you can't do async calls to it.

Re: Building a JavaScript array by paging through HyperCube pages in AngularJS extension

vighnesh_gawad — Thu, 31 Oct 2024 13:08:36 GMT

Hi @frankpacker_AoD ,

Here we are getting hypercube of extension that we have created. Is there way we could get similar for any Object with their ObjectID?

Re: Building a JavaScript array by paging through HyperCube pages in AngularJS extension

frankpacker_AoD — Thu, 31 Oct 2024 22:00:32 GMT

Sure - if you add /options/developer to the end of your QS URL you'll be able to right-click on any object and see the developer options. From there you can access the Hypercube of that object

Re: Building a JavaScript array by paging through HyperCube pages in AngularJS extension

vighnesh_gawad — Mon, 04 Nov 2024 10:32:59 GMT

Actually I meant how can we get hypercube of different object using javascript in Qlik extension.

But thanks for help anyway.