Guriddo » Topic: Capture sql string used to create filtered grid

Capture sql string used to create filtered grid

Guriddo
Capture sql string used to create filtered grid

This topic has 2 replies, 2 voices, and was last updated 7 years, 2 months ago by sagana.

Creator

Topic
January 11, 2018 at 3:31 pm #126571

sagana
Participant

Is it possible to capture the sql string including the relevant where clause used to create a grid after adding search criteria or does one have to capture the array of arrays of search criteria and build the where clause for the sql string from there.

If the former, please let me know how to access the generated sql string.
Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies

January 12, 2018 at 11:56 am #126573

tony

Keymaster

Hello,

Currently there is no build in such method, but there is a method where
you can obtain the WHERE clause when a search is in action.

This is done with the method builSearch

This can be something like this:

Code:


...
// Check to see if we are in search mode
$search = jqGridUtils::GetParam("_search");
//
if($search == 'true') {
// if we aare in search get the where clause
$where = $grid->buildSearch( '' );
// do what you want
} else {

...

}

...

// Check to see if we are in search mode

$search = jqGridUtils::GetParam("_search");

if($search == 'true') {

// if we aare in search get the where clause

$where = $grid->buildSearch( '' );

// do what you want

} else {

...

}

So after you are in search mode and the user activate the search the $where look like:
“(OrderID = ‘10248’ AND ShipName = ‘Vins’ )”
Youi can pass your own filters to it. A second parameter determines return mode

Regards

January 15, 2018 at 11:00 am #126574

sagana

Participant

Thank you Tony, that works well.