We want to try flexmonster for our application but we can't use static SQL the way it is described here:
It's because our DB schema allows users manually editing columns and data in the columns, so we have a bunch of SQLs to get the data and these SQLs are dynamic depending on the DB data, and we just can't get ALL of the data at once in one SQL. So, we wonder if there is any workaround that would allow us to achieve the goal. One idea is if its possible to have code that would create an index with its SQL each time we generate the new SQL in our code. In Flexmonster docs its done only once through UI.
Thank you for reaching out to us.
Please note that Flexmonster Data Server does not support the described approach for dynamic data querying. However, you can implement your own server endpoints to pass the data from SQL to Flexmonster. Here is the list of other ways to connect to your SQL database:
We recommend checking our documentation page for more information about these approaches, including their advantages and disadvantages: https://www.flexmonster.com/doc/connect-to-relational-database/
Please let us know if one of the suggested alternatives would work for you.
Hope you are doing well.
We are wondering if you looked through the recommended FDS alternatives for connecting to SQL.
Please let us know if one of them would fit your use case.
Yeah, I was able to achieve the right dynamic behavior by using CSV format. Still having some minor issues, so may ask some questions later on if not able to resolve myself.
Thank you for the updates.
We are glad to hear that you were able to find a solution for dynamic behavior.
Feel free to contact us if any assistance is required.