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
Dynamic Filtering
-
- Posts: 72
- Joined: Mon Jun 07, 2010 2:39 am
Dynamic Filtering
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.
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.
-
- Posts: 1
- Joined: Sat Dec 10, 2016 1:20 am
Re: Dynamic Filtering
Hi any update news about this (Dynamic Filtering) or something similar in Stimulsoft latest version? Thanks,
Re: Dynamic Filtering
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.
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.