how to use the custom sql in custom export with filter range?
i tried using the select command but i get some issue while adding data with dependent dropdowns .
So i have modified the Custom export
$sql = $param["sql"];
with my own sql
it works well but it shows all the records.
It would be very useull if you can help .
You can use following as example:
// append WHERE clause if available
$export_where = $_SESSION["jqgrid_list1_filter"];
$sql = "SELECT ".implode(", ",$fields)." FROM ".$grid->table. " WHERE 1=1 ".$export_where;
Here list1 is grid id.
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!