Hello,
When Using the custom API is it possible to effectuate the /members request only when the member is about to be filtered?
I have a situation where the members request returns 100000+ values but after the pivot as been constructed only 10 value remain for that column. the best would be that the /members request would be effectuated when the user open the filter windows and not before
thanks
Hello, Cedric,
Thank you for your question.
We would like to explain the logic of sending the requests in more detail. In our component, the /select
request is performed after all members are uploaded. This means that the /members
request must be sent before /select
.
Do not hesitate to contact us if any other questions arise. We will be glad to help you.
Best regards,
Milena
Hello Milena,
Thank you for answering.
Is there any way to hide members from the filter windows after the /select request has been effectuated?
Awaiting your answer
Hi, Cedric,
Thank you for your question.
To hide all members shown in the filter pop-up, we suggest specifying members: false
in the filters
object of the /fields request. Please kindly note that there is no configuration to hide specific members.
In case it is needed to display only some of the members in the filter window, the only possible solution we see now is to create a custom filter pop-up and show only specific members depending on your custom logic. But you will need to hide the default filter and implement a custom one using Flexmonster API for that.
Please let us know if it helps.
Kind regards,
Milena
Hello Milena,
I Think dynamic filters are a must have for any kind of datatable / pivot tool and would kindly like to request for your team to work on an implementation.
Unfortunately the solution you have given to me is very impractical at the moment because:
If you can help me solve either the first two or the last point I put above then I would be able to implement a custom dynamic filter option while (hopefully) waiting for an official version
Hello, Cedric,
Thank you for sharing your suggestions on Flexmonster functionality and for giving an update on your progress.
Our team is currently working on your case.
We will make sure to reach out to you shortly.
Best regards,
Milena
Hi, Cedric,
We have carefully checked all points that you specified.
Our team would like to provide an example showing the recommended approach to create a custom filter pop-up.
Please see https://jsfiddle.net/flexmonster/356rsy8o/.
In the example, we hid the Flexmonster filter pop-up and created a custom one. Then we added an Apply button with the setFilter on click to the pop-up.
To show only the members displayed on the grid in your filter window, you need to implement the custom logic to retrieve such members. It can be done by adding a new endpoint on your server.
Then, you can send the new request (not the request that Flexmonster sends) to the server when opening the pop-up.
In the request, send the hierarchy name and the slice, and return the members of the hierarchy that you want to show for the current slice.
Please kindly note that the example above is created to demonstrate the main idea.
You are welcome to customize it to your needs.
Also, could you please let us know if the suggested approach helps?
Waiting for your reply.
Kind regards,
Milena
Hello, Cedric,
Hope you are doing well!
We were wondering whether our response helped.
Could you please let us know if the suggested approach works for you?
Waiting for your reply.
Best regards,
Milena
Hello Milena,
I’m very well thank you.
I’ll be working on this in early January, I’ll let you know if it fixes my issues.
Regards,
Kalume Cedric