Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

Views and Stored Procedures

Answered
Erik Lacson asked 7 days ago

I’m trying to call a view or a stored procedure as the query string in the Flexmonster Data Server json config file. When I point to the data server API, it would only retrieve the column names from the view or a stored procedure, but not the data. Is there a proper way of using views or stored procedure? My straight SQL query is too long an complex to put inside the JSON config file.
 
 

1 answer

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster 6 days ago

Hi Erik,
 
Thank you for posting your question.
 
It seems like a reasonable solution for you would involve referring to the Data Server as to a DLL.
 
This approach allows you to customize the Data Server to suit your needs better. You can, for example, implement your own parser in a way that processes the results of your stored procedures – this is not available in the default Data Server, distributed as a ready-to-run .exe file.
 
For more info on Flexmonster Data Server as a DLL check out the following documentation page: https://www.flexmonster.com/doc/getting-started-with-data-server-dll/.
Also, here is a step-by-step tutorial on implementing a custom parser for the Data Server: https://www.flexmonster.com/doc/implementing-custom-parser/.
 
Please let us know if this helps.
 
Kind regards,
Mykhailo

Please login or Register to Submit Answer