jQuery Grid Plugin - jqGrid - Topic: bug in local searching

OlegK on bug in local searching

Tue, 29 Jan 2013 12:48:36 +0200

Sorry! It was my error... 🙁

tony on bug in local searching

Tue, 29 Jan 2013 12:40:39 +0200

Oleg,

The demo you pointed does not contain my fix. Can you please correct and try it with it.

Regards

OlegK on bug in local searching

Tue, 29 Jan 2013 12:35:36 +0200

I think that the previous fix which you posted is still buggy. I descibes the problem in the comment. I'm not sure that the changes which I suggested in the pull requests fixes all current problem, but at least the appling of the same filter on the demo which uses my suggestion works correctly.

Best regards
Oleg

OlegK on bug in local searching

Sat, 26 Jan 2013 14:51:14 +0200

Hello Tony,

it seems to me that I fond a simple fix of the problem. I posted the pull request with the corresponding suggestion.

Best regards
Oleg

tony on bug in local searching

Fri, 25 Jan 2013 15:19:36 +0200

Hello Oleg,

Thanks. I confirm the bug. From what I currently see it will be very hard to fix, but I will

Best Regards

Tony

OlegK on bug in local searching

Thu, 24 Jan 2013 18:09:24 +0200

OK I included showQuery: true option in the demo. One can see now that the correct query

((name = "test5") OR name = "test6")

will be created by filter module and postData.filters is also correct

"{"groupOp":"OR","rules":[{"field":"name","op":"eq","data":"test6"}],"groups":[{"groupOp":"AND","rules":[{"field":"name","op":"eq","data":"test5"}],"groups":[]}]}"

or in object form as

{
groupOp: "OR",
rules: [
{field: "name", op: "eq", data: "test6"}
],
groups: [
{
groupOp: "AND",
rules: [
{field: "name", op: "eq", data: "test5"}
],
groups: []
]
}

Just the local searching works wrong with the data.

Best regards
Oleg

tony on bug in local searching

Thu, 24 Jan 2013 17:56:22 +0200

Thanks Oleg,

Before I look in this you can set showQuery param in filtering to see what search string is builded.

Regards

OlegK on bug in local searching

Thu, 24 Jan 2013 17:38:08 +0200

Hello Tony,

I read about the bug some days before (see here), but hadn't time to fix the problem till now. So I decide to describe the bug first of all.

Let us we have simple local grid like here. If we would use the filter

or another one

we will see correct filtering results with two rows (one having "test6″ and another having "test5″). The problem (the bug) can be reproduce if we would use mix between rules and groups parts of the filters.

Applying of such filter produces no rows because AND operation between two suboperations will be used instead of OR.

I hope Tony, that you'll quickly find the place in the code which is the origin of the problem and will fix the bug.

Best regards
Oleg