Search form not reloading/requerying properly with filters

QuestionsSearch form not reloading/requerying properly with filters

When I use a search form even with $grid["persistsearch"] = true; I get weird errors when using the autofilter. It is like it loses that search form parameters.

For example,
1. I set a date range: https://snag.gy/icwlnE.jpg –Notice I have 1909 records.
2. I filter for a specific Truck. https://snag.gy/SHyN9F.jpg –Notice I know have 3,571 records?

The same thing happens with all other filter/search fields also.

Any thoughts?

Dave

Here are my grid options:
$grid["sortname"] = 'id'; // by default sort grid by this field
//$grid["cellEdit"] = true;
$grid["sortorder"] = "desc"; // ASC or DESC
$grid["caption"] = "Paperwork Check"; // caption of grid
$grid["autowidth"] = true; // expand grid to screen width
$grid["multiselect"] = false; // allow you to multi-select through checkboxes
$grid["rowNum"] = 30;
$grid["pgbuttons"] = true;
$grid["viewrecords"] = true;
$grid["rowList"] = array();
$grid["export"] = array("format"=>"excel", "filename"=>"TimeTable", "sheetname"=>"TripTimes");
$grid["form"]["position"] = "center";
$grid["edit_options"] = array('width'=>'500',"height"=>'500');
$grid["height"] = "690";
$grid["persistsearch"] = true;

$g->set_options($grid);

2 Answers
Abu Ghufran answered 5 years ago

Hi,

I've regenerated this issue and will be updating back with solution.

David Collett answered 5 years ago

Not the most elegant way but I fixed by using GET method and passing date range to my sql query. So I think I am good.

Your Answer

13 + 14 =

Login with your Social Id:

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 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

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

Let us improve this post!

Tell us how we can improve this post?