Dear visitor, despite the COVID-19 outbreak, our team continues operating at full speed.

Also, here is the form where you can apply for a special discount and we will contact you with possible options. Stay safe and continue achieving your business goals.

Fill the form
Get Free Trial
Get Free Trial

Getting field property under the drill-through view

Sergii Valko asked on May 20, 2020

Hello, during implementation of clickable cells functionality there is a need to get a value of field property(type=’property’). But under drill-through view, it seems unreachable. The main goal is that in generated URL as value should be placed some property(e.g. userId) instead of member caption(e.g. userName), but at the same time a hyperlink caption should be user friendly(e.g. userName). At the pivot table, it works perfectly and was achieved through ‘customizeCell()’ function. How to do the same under drill-through view? In other words, how to derive property of field under drill-through view. Thank you in advance.

1 answer

Illia Yatsyshyn Illia Yatsyshyn Flexmonster May 21, 2020

Thank you for reaching out to us.
Our team would like to kindly explain that the field marked as a property is associated with an exact member of the hierarchy. Being opened in the drill-through, cells are not considered members; therefore, their Cell Data object does not contain information about properties.
Our recommendation is to pass URL separately from the main data set and apply formatting using custom logic. The name of the member can be used as an identifier. Please see an example demonstrating such an approach.
The object urlList is used as a storage for links. The customizeCell function uses the name of the scanned member in order to retrieve the matching URL from the object.
We sure hope it works for your case.
Do not hesitate to contact us in case additional questions occur.
Kind regards,

Please login or Register to Submit Answer