Identify detail rows

Answered
Francesco asked on April 29, 2018

My goal is to identify all the detail rows that are part of an aggregate cell. The rows that I would like to get are the same that appear in the detail popup when I double click on a cell, but at the moment I can not find a method with which I can easily identify them. Can you help me to identify these rows?

3 answers

Public
Dmytro Zvazhii Dmytro Zvazhii Flexmonster April 30, 2018

Hello Francesco, 
Thank you for your question. We have some plans on implementing such functionality in our future releases but for now, it is not available. As a workaround, you can use exporting feature to get the information from detail pop up. Please find more information about our exporting feature here: https://www.flexmonster.com/doc/export-report/.
Let us know if you have any other questions.
Regards,
Dmytro

Public
Francesco April 30, 2018

Hello Dmytro, 
Thank you for your answer. I read the link but I would need to get the detail rows without opening the popup. The use case I would like to do is this:

  • make the grid cell editable -> done returning an <input> from the customizeCell method
  • change the cell value and process the new value with my personal business logic
  • reflect the result on the pivot using updateData -> here it would be necessary to have the detail of involved rows to make a partial update.

Can you give me some suggestions on how to do it or in alternative can you tell me when this functionality will be available?
Regards
Francesco

Public
Ian Sadovy Ian Sadovy Flexmonster May 1, 2018

Hello Francesco,
 
Thank you for the details.
We can suggest you the following workaround:

  1. make the grid cell editable using the customizeCell method and listen for the input change
  2. on change get cell details. It contains columns, rows and measure property that can help to identify affected data
  3. using your custom logic update the data and reload it to the Flexmonster

The sample for steps (1) and (2) you can find in the following JSFiddle: https://jsfiddle.net/flexmonster/m6d9tp61/
 
Please let me know if it helps.
 
Regards,
Ian

Please login or Register to Submit Answer