Evan Shen
09/08/2021, 8:14 PMJiri Zajic
09/08/2021, 8:38 PMJiri Zajic
09/08/2021, 8:40 PMconst firstPage = await result.readWindow([0, 0], [10, 10]);
.Jiri Zajic
09/08/2021, 8:46 PMEvan Shen
09/08/2021, 9:27 PMEvan Shen
09/14/2021, 8:34 PMJiri Zajic
09/15/2021, 4:54 AMJiri Zajic
09/15/2021, 4:56 AMconst result = await backend
.workspace("workspace_id")
.execution()
.forItems(measuresAndAttributes, [filter])
.withSorting(...sort)
.withDimensions(...dimensions)
.execute();
const firstPage = await result.readWindow([0, 0], [10, 10]);
const allData = await result.readAll();
And now you're looking for a way to just call the .forItems(measuresAndAttributes, [filter])
again, only with updated filters array?Evan Shen
09/15/2021, 3:28 PMEvan Shen
09/15/2021, 4:57 PMJiri Zajic
09/16/2021, 11:50 AMEvan Shen
09/16/2021, 7:36 PMgetRows(params)
callback where params
contains the sort, filter, and infinite scroll position information.
This made it very simple to get a new set of rows as the user scrolls, but when it came to applying ag-grid defined sorts and filters I had to build a new execution first before actually performing the read queryJiri Zajic
09/16/2021, 7:54 PMEvan Shen
09/16/2021, 8:05 PMEvan Shen
09/24/2021, 8:40 PMforBuckets
instead of forInsightByRef
since I want to be able to dynamically add and remove attributes/measures to the execution. How do I convert a ICatalogFact and ICatalogAttribute to a measures and attributes to use with forBuckets
?Jiri Zajic
09/26/2021, 5:05 PMforBuckets
I would recommend you to try forItems
, it could look something like this:Jiri Zajic
09/26/2021, 5:05 PMconst measure = Ldm.Revenue;
// const measureFromFact = Ldm.Budget.Sum;
const viewBy = Ldm.DateDatasets.Date.Month.Short;
const stackBy = Ldm.ProductCategory;
const result = await backend
.workspace(workspace)
.execution()
.forItems([measure, viewBy, stackBy], [dateFilter, attributeFilter])
.withDimensions(...newTwoDimensional([viewBy], [MeasureGroupIdentifier, stackBy]))
.execute();
Jiri Zajic
09/27/2021, 9:55 AMLdm
variable is a product of Catalog Export, please read https://sdk.gooddata.com/gooddata-ui/docs/export_catalog.html for more.Evan Shen
09/28/2021, 3:02 AM