asked on March 7, 2022
Hi,
Is it possible to have some way to listen to the cell expand event? We want to pass some parameters by
customizeAPIRequest when the cell expands event trigger. I notice that there is a flexmonster.on()
method but I can't find expand event in the list of events. How can I achieve this demand？
Kind Regards
Carrie
⋅ March 8, 2022
Hello, Carrie,
Thank you for reaching out to us.
Currently, Flexmonster does not provide an option of listening to the cell expand event. Could you please tell us how critical it is for your case?
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 9, 2022
Hi Nadia,
Thank you for your response.
Listening to the cell expand event is very important to our project. The server-side needs to know if the select request was sent by expanding event. Is it possible to add expand event to the list of events recently or in the near future？
Looking forward to your reply.
Thanks & Regards
Carrie
⋅ March 9, 2022
Hello, Carrie,
Thank you for your response.
Our team understands that you want to use the expand event to pass the necessary parameters to customizeAPIRequest. However, we still need more details on why the server side needs to know about expanding. Custom data source API isn't intended to know if the request was sent from expanding or any other operation. The server passes data based on the received request.
We would be grateful if you provided us with more information on usage of the cell expand event in your use case. It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 10, 2022
Hello Nadia，
Our project is a financial system. The server side needs to go through complex calculations to return
the data for the pivot table. In order to improve the query speed of the server and reduce
unnecessary queries, for example, when clicking to expand, only the rows to be expanded are
queried. For data, such as unnecessary Grand total and Sub total.
we need to know the request Whether it comes from the expanded operation, because it is
impossible to distinguish the difference between the request sent by the expand operation and the
request sent after setting the report filter, so a request header parameter needs to be passed in the
request sent by the expand.
Thanks & Regards
Carrie
⋅ March 11, 2022
Hello, Carrie,
Thank you for providing a detailed explanation.
Your suggestion on adding the information on whether the request comes from the expand sounds reasonable. But instead of an event, we will add a flag to the select request to tell if the request was sent from the expanding. Our team will provide this feature with our minor release with the ETA April 4th.
Please let us know if it would work for your case.
Kind regards,
Nadia
⋅ March 22, 2022
Hello, Carrie,
Our team is glad to announce that a new parameter querytype was added to the /select request.
This feature is available in the 2.9.21 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-21/
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ March 23, 2022
Hello there, could we get a little bit more documentation what this querytype field does, specifically: what are its possible values?
⋅ March 23, 2022
Hello,
Thank you for your question.
The querytype property of /select request is describing the type of select request, which is sent to the server.
Possible values of this property: select - loading aggregated data on a top levelexpand - expanding values drillDown - drill down hierarchical values
Feel free to contact us if more questions arise.
Best Regards,
Maksym
⋅ April 15, 2022
Hello Nadia,
I have upgraded flexmonster version to 2.9.22, and now the backend can judge if the request was sent by the expand event. This helps us a lot, thank you very much.
Thanks & Regards
Carrie
⋅ April 15, 2022
Hello, Carrie,
Thank you for the feedback.
Our team is happy to hear that it works well for you.
As always, feel free to contact us if other questions arise.
Kind regards,
Nadia
