Need a special offer?Find out if your project fits.

How to retrieve data of not visible fields

Cristina 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

3 answers

Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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:
You can read more about customizing the context menu by the link:
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,

Cristina March 16, 2023

Hello Solomiia,
It works for me, thank you so much for your answer.

Solomiia Andrusiv Solomiia Andrusiv Flexmonster 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.


Please login or Register to Submit Answer