Dynamic Filtering

[tony.tomov]

Hello,

Since I like too much your product and the way they is developed I have prepared for my needs a
dynamic filtering.
I hope that such kind of feature will be available soon in the product.

The reason that I create this is simple:
The end user should select conditions easy and based on these conditions to run the report.

The build in filter feature is great, but it is not effective when the query return relative big data.

Based on the parameter which can be included into the SQL query {} I have created a Java Script
dialog (using jQuery and jQuery UI) where the user can select field(s), conditions and data related to it.

To implement in the report we need just to create only one parameter like this

"SELECT * FROM table WHERE a=b AND {filter}"
everything then is done with little PHP code.

The project is just in initial stage.
There are a lot of other things to do , but this is the main idea.
For better security implementation I plan in the future to post only one JSON string and then get the string server side
with the appropriate checking.

For now you can view the Implementation here:

http://www.trirand.com/stimulsoft/filtertest.php

Enjoy

Kind Regards
and thanks again for the great product

Tony

[Vladimir]

Hello, Tony

Thanks for the idea with the filters, we will consider this feature. Now we fully remade the variables algorithm, perhaps we add a filter for SQL queries in a similar way.

Thank you.

[malighufron]

Hi any update news about this (Dynamic Filtering) or something similar in Stimulsoft latest version? Thanks,

[HighAley]

Hello.

The Filtering on the query side is already available.
Also the filter could be dynamic.
You could use variables for this and can request data from users.

Thank you.