asked on August 7, 2022
I have a question if it is possible to customize queries by sending them a parameter, e.g. SELECT * FROM users WHERE id = param
⋅ August 9, 2022
Hello, Michał!
Thank you for reaching out to us.
Currently, Flexmonster Data Server does not support the queries with parameters. Hence, we suggest two alternative approaches for adding custom query filters with SQL data sources - using Flexmosnter Data Server as DLL or implementing the custom API data source.
Flexmosnter Data Server DLL
Flexmonster Data Server can be embedded into the .NET Core project as a DLL – a separate flexible module. FDS DLL allows you to implement the custom server filters with any data source.
The general idea behind the server-side filtering is:
customizeApiRequest() API call to include the filter parameter in the request header.Please check the following guide for server filter implementation.
Custom API data source
As an alternative to Flexmonster Data Server, you can implement your data service using the custom API - communication protocol that allows you to retrieve aggregated data from a server to Flexmonster Pivot. This approach requires more effort but allows using any programming language for implementation. Please see more detailed instructions for implementing the custom API data source.
We would be glad to hear your feedback regarding which options you have decided to choose.
Also, feel free to contact us if any other questions arise.
Best Regards,
Maksym
⋅ August 18, 2022
Hello, Michał!
Hope you are doing well.
Our team would like to know if you had time to check the suggested approaches for adding custom filters.
Please let us know which of these options is better for you.
Best Regards,
Maksym