React pivot table expand and open a custom dialog

[JORGE V]

Hi, 

In pivot table : 

    1) Expand

     I have a group settings configuration : 

    groupSettings: [        

            { name: 'fecha', type: 'Date', groupInterval: ['Years', 'Months','Days'] }         

        ],   

   ¿ Is there any way to expand intially years and months but not days (with expandAll property all values are expanded) ?

  2)   Dialog for custom action.

 

    ¿ Is there any way to open a custom dialog when the user clicks on grid (or similar) ?

     I would like to open a dialog with a datePicker control and a button to do a massive modification of dates.

     (Now, a dialog is open with the N rows and it is possible to edit the values one by one). 

Thanks in advance !

Jorge

[Saranya Sivan]

Hi Jorge, 

  

We are validating the reported requirement at our end. We will update the further details within two business days. 

  

Regards, 

Saranya S. 

 

[Saranya Sivan]

Hi Jorge, 

 

Please find our response in below. 

 

Query	Response
Is there any way to expand initially years and months but not days.	Kindly follow the UG documentation to expand all the members except specific members.  https://ej2.syncfusion.com/react/documentation/pivotview/drill-down/#expand-all-except-specific-members    Meanwhile we have prepared a sample to achieve your requirement using load event which is available in the below link.     Sample: https://stackblitz.com/edit/react-s6dy8x-gu2lz7?file=index.js
Dialog for custom action.	Kindly follow the UG documentation to mute the drill-through dialog and get raw data information of the aggregated cell.    https://ej2.syncfusion.com/react/documentation/pivotview/drill-through/#drillthrough    With the above information, you can bind your own dialog with required details.
To do a massive modification of dates	Kindly update the modified raw data in the “dataSource” property under “dataSourceSettings”.

 

Regards, 

Saranya S.