🍉 Meet Flexmonster Pivot Table & Charts 2.9.Check out all the hot features!
Get Free Trial

Views and Stored Procedures

Answered
Erik Lacson asked on April 29, 2021

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 April 30, 2021

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