custom export

Questionscustom export
german asked 2 years ago

sir,

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 .

thank you

2 Answers
Abu Ghufran answered 2 years ago

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.

germanmary answered 2 years ago

Thank you so much sir.

It is really an useful help

Thanks a lot

Your Answer

16 + 7 =

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating / 5. Vote count:

As you found this post useful...

Follow us on social media!

We are sorry that this post was not useful for you!

Let us improve this post!