Hello!
With the help of capability API, I'm rendering a QS visual (e.g.: a table or a pivot table ) in a razor page.
It seems straightforward, the results are almost successful apart from large objects when I encounter the Result too large error.
Basically, it boils down after all the boilerplate to:
var object = app.getObject("html_div_for_object", objectId);
My question is how should I retrieve these large objects that output the "Result too large" error, or calculate/retrieve its data, in order to render it with the same method that CapabilityAPI provides getObject?
LE: I know about the 10k limitation of a data page so I've tried something like this. It seems no of pages are retrieved correctly, but no data.
var pageSize = 100;
var totalPages;
var layout = null;
function retrieveDataPage(page) {
app.getObject("html_div_for_object", objectId).then(function(model) {
try {
var pageOffset = (page - 1) * pageSize;
var requestPage = [{
qTop: 0,
qLeft: 0,
qWidth: layout.qHyperCube.qSize.qcx,
qHeight: pageSize,
}];
} catch (err) {
console.log("err", err);
}
});
}
app.getObject("html_div_for_object", objectId).then(function(model) {
model.getLayout().then(function(returnedLayout) {
layout = returnedLayout;
var totalDataCount = layout.qHyperCube.qSize.qcy;
totalPages = Math.ceil(totalDataCount / pageSize);
console.log("totalPages", totalPages);
retrieveDataPage(1);
});
});
