asked on March 15, 2023
I need to retrieve data from fields that are not visible in the report when I make right click on a cell, is there a way to do it?
Thank you so much
⋅ March 15, 2023
Hello, Christina!
Thank you for contacting us.
Kindly note that additional data from the data source can be retrieved by using the getMembers() API call, which returns all the members of the specific hierarchy.
By design, Flexmonster opens the context menu on the right-click on the cell, so the additional functionality to the following event can be added using customizeContextMenu() API call:
flexmonster.customizeContextMenu(function(items, data, viewType) {
//your additional functionality here. For example:
const categories= flexmonster.getMembers('Category');
//returning the context menu tabs, or [] to hide the context menu
return items;
});
We have prepared a JSFiddle sample for illustration: https://jsfiddle.net/flexmonster/su695k4n/.
You can read more about customizing the context menu by the link: https://www.flexmonster.com/doc/customizing-context-menu/.
Hope you will find our answer helpful. Please let us know if the suggested approach works for your case.
Looking forward to your response.
Kind regards,
Solomiia
⋅ March 16, 2023
Hello Solomiia,
It works for me, thank you so much for your answer.
Cristina
⋅ March 17, 2023
Hello, Christina!
Thank you for your feedback.
We are glad to hear that our solution was helpful.
Feel free to contact us in case of any other questions.
Regards,
Solomiia