Hello,
is it possible to udpate the data of a Pivot Grid after it is generated?
In our use case, we want to use Pivot Grid as a simple Cross-Table, with "showPivotConfigurationUI" as "false". The data, which is bound to the Pivot Grid, will be changed by components outside of the Pivot Grid. We want to update the Pivot Grid once the data is changed. Is is possible? Thanks in advance.
Add an example to explain what I want to do.
Suppose I get this data.
[ {fact: F1, market: Market1, product: Prod1, value: 1}, {fact: F1, market: Market1, product: Prod2, value: 2}, {fact: F2, market: Market1, product: Prod1, value: 3}, {fact: F2, market: Market1, product: Prod2, value: 4},]
I want to create such a table. Once the product is changed, the table should be changed accordingly. Is there any way to do that? Many thanks.
regards
CC
Hello Clever Click,
Thank you for posting in our Community!
I believe you will find the Pivot Grid Remote Operations topic in our official documentation very helpful. There you can find more information regarding how to feed the pivot grid with already aggregated data. Please keep in mind that as stated in this topic, it is essential for the data to match the configuration of the pivot grid. For the best results no additional fields should be included into the aggregated data and no fields from the provided data should be left undeclared as rows or columns. The IgxPivotGrid component builds its data based on the PivotConfiguration and it is expected for the configuration and aggregated data to match accordingly.
Please let me know if you need any further information.
Regards,Viktor KombovEntry Level Software DeveloperInfragistics, Inc.
Hello Viktor Kombov,
thank you very much for your answer.
I have tried with Pivot Grid Remote Operations. It looks good, but I have some questions. It would be easier if I show you my test.
I have these data:
Hello Clever,
I have created a small sample demonstrating how to filter multiple columns by passing to the filter method FilteringExpressionsTree instead of IgxFilteringOperand:
public onFiltering() { const productFilteringExpressionsTree = new FilteringExpressionsTree( FilteringLogic.Or, 'Product' ); const productExpressions = [ { condition: IgxStringFilteringOperand.instance().condition('contains'), fieldName: 'Product', ignoreCase: true, searchVal: 'Accessories' }, { condition: IgxStringFilteringOperand.instance().condition('contains'), fieldName: 'Product', ignoreCase: true, searchVal: 'Bikes' }, ]; productFilteringExpressionsTree.filteringOperands = productExpressions; this.grid.filter('Product', null, productFilteringExpressionsTree); }
Please test the sample on your side and let me know whether you find it helpful.
Looking forward to hearing from you.
Regards,Viktor KombovEntry Level Software DeveloperInfragistics, inc.
Hello Viktor,
Is there anything else I can help you with?