Way to do deeper customization of pivot grid detail dialog?

Way to do deeper customization of pivot grid detail dialog?

Posted by: nwallace on 12 December 2022, 7:14 am EST

• 

  nwallace

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 12 December 2022, 7:14 am EST - Updated 12 December 2022, 7:19 am EST

  We have a use case where, when a user is viewing some pivoted data (client side pivot data), when they double click on a pivot cell, we want the popup to include extra information not included in the originally pivoted data. To do this, we would like to hook into the detail view to get the columns and filters applied for the selected cell

  So if we had a pivot grid like so:
  
  

  for the selected cell, I would like to have a list of the column filters that apply, in this case:

  • buyer=Dad
  • Type=fuel

  so that I can feed this information to a call to a backend service.

  Is there a way to get this information when a double-click happens?

• 

  vivek.pannu

  

  • Post Options:
  • Link
    Copy

  Posted 13 December 2022, 3:57 pm EST

  Hi,

  You can handle ‘mousedown’ event on the pivotGrid’s host element, and get the desired information by using pivotGrid’s ‘hitTest’ method.

  Please refer to the following sample for the same - https://stackblitz.com/edit/js-dzkrt3?file=index.js

  Regards,
  
  ~Vivek

• 

  nwallace

  • Post Options:
  • Link
    Copy

  Posted 14 December 2022, 7:31 am EST

  Thank you! This is perfect.