Need a special offer?Find out if your project fits.
+

database query parameters

Answered
Michał 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

2 answers

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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:

  • Use the customizeApiRequest() API call to include the filter parameter in the request header.
  • Depending on the received data from the client, the DLL can apply the appropriate filter to the data.
  • The server sends the specific dataset to Flexmonster.

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

Public
Maksym Diachenko Maksym Diachenko Flexmonster 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

Please login or Register to Submit Answer