The execution query is changed by the user’s call parameters.
If you use flexmonster data server, connect database in config file and write query.
Is there a way to change this query dynamically?
If there is no way, please let me know if there is a bypass method that can be used dynamically.
Also, I am wondering when to execute the query defined in this data server config file.
Each call, or just the first time
Thank you for reaching out to us.
Concerning dynamic updates of queries.
Our team would like to kindly explain that Flexmonster Data Server relies on the set of predefined indexes that cannot be changed during runtime. As for now, no acceptable workaround for such a limitation exists.
Even so, we suggest considering the possibility to implement your own server based on the custom data source API, that would support the required functionality. The Flexmonster custom data source API is a communication protocol that allows exchanging aggregated data between your data layer and Flexmonster Pivot Table & Charts.
To provide you with illustrative examples, we developed two ready-to-check Node.js and .NET Core servers.
Note that these are only the samples, and the implemented logic of data processing may differ from what you need. You can use them as a core for building a custom connector.
As a starting point, we highly recommend jumping into the Quick start guide. This guide provides step-by-step recommendations to help you get going with the API. In the Custom API requests section, you will find all the front-end and back-end specifications of the API. There you will also be able to check the examples of requests and responses for different queries.
Concerning the execution of the query defined in the configuration.
The query is executed right after the server is started. It means the data is loaded to the server once and stored in the RAM of the server.
Flexmonster Data Server allows refreshing the data with a specific interval. It is achievable using the
DataRefreshTime property of the
DataStorageOptions object. It can be adjusted in the configuration file. If the
DataRefreshTime is not specified, the data will not be reloaded.
We hope it helps.
Do not hesitate to contact in case other questions occur.