How to block drill-through viewing for a specific cell

Hello,

Thank you for contacting us.

Currently, it is only possible to enable or disable the drill-through view for all the cells simultaneously using the drillThrough option. Alternatively, you can set the drillThrough property to false and use the celldoubleclick event to implement your custom drill-through feature. Please check our documentation for more details: https://www.flexmonster.com/api/celldoubleclick/.

You are welcome to contact us if other questions arise.

Kind regards,
Nadia

Hello,

Thank you for the feedback.

Currently, there are no plans to add the functionality to prevent showing the drill-through view for the specific cells. However, you can use the following workaround:

You can create a function to check the cell properties and add the CSS styles to hide the pop-up window. For example:

function customDrillThrough(cell) {
  if (
    cell &&
    cell.rows[0] &&
    cell.rows[0].uniqueName &&
    cell.rows[0].uniqueName == "status.[inactive]"
  ) {
    document.querySelector(".fm-drillthrough-view").style.display = "none"
    document
      .querySelectorAll(".fm-ui-modal-overlay")
      .forEach((element) => (element.style.display = "none"))
  }
}

Additionally, it is necessary to remove the "Drill Through" option from the context menu for those cells:

function customizeContextMenuFunction(items, data, viewType) {
  if (
    data.rows[0] &&
    data.rows[0].uniqueName &&
    data.rows[0].uniqueName == "status.[inactive]"
  ) {
    items = items.filter(function (item) {
      return item.label !== "Drill through"
    })
  }
  return items
}

Then, add the created functions to the Flexmonster constructor:

const pivot = new Flexmonster({
  // other properties
  customizeContextMenu: customizeContextMenuFunction,
  celldoubleclick: customDrillThrough,
})

In the following JSFiddle, the drill-through functionality is disabled for the "Inactive" value: https://jsfiddle.net/flexmonster/dv41s3hr/.

We hope it helps. You are welcome to contact us if other questions arise.

Kind regards,
Nadia