jQuery Grid Plugin - jqGrid - Topic: Trouble with filters http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters Simple:Press Version 5.7.5.3 TheCore on Trouble with filters http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p24021 Bugs http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p24021 Hello,

I tested 4.1.2 ...

Now multiple groups seem to work fine ... hard coded on server side as well as user-driven on client side.

But I think there is a further bug:
If I try to combine groups with separate rules, whose item being also used in the group, then I always get an empty table.

Let me explain:

(booking = "" AND cancellation = "") OR (booking != "")
...booking is used in the group and as a single rule at the end of the term. The term should return all reservations and all bookings, but all I get is an empty table ... hard coded on server side as well as user-driven on client side.

but if I express the separate rule as a group ...

(booking = "" AND cancellation = "") OR (booking != "" AND booking != "")

... everything is working correctly.

Thanks in advance

]]> Thu, 21 Jul 2011 02:32:05 +0300 TheCore on Trouble with filters http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p23994 Bugs http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p23994 Hello,

thank you for answering.

I could verify this behaviour in both cases - hard coded on server side AND user-driven on client side.

Thanks

Michael

]]> Tue, 19 Jul 2011 13:58:40 +0300 tony on Trouble with filters http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p23992 Bugs http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p23992 Hello,

Are you using server side code to perform the search or you use a local searching.

If this is the second case there was a bug which is fixed.

Tomorrow we will publish a new bug fix release.

Kind Regards

Tony

]]> Tue, 19 Jul 2011 11:54:59 +0300 TheCore on Trouble with filters http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p23990 Bugs http://www.trirand.com/blog/?page_id=393/bugs/trouble-with-filters#p23990

Hello,

sorry … but I still having trouble with the usage of multiple groups in jqgrid. I hope you can help me.

Well, let me explain the situation.

I have to implement a simple booking system. In the backend of this system I use jqGrid to display all reservations, bookings and cancellations in a table. It is possible to cancel a reservation, but not a booking.

The backend user should be able to use 3 filter options stand-alone or in combination:

- Reservations – displays all records, where booking and cancellation is an empty string: (booking = "" AND cancellation = "")

- Bookings – displays all records, where booking is set by timestamp: (booking != "")

- Cancellations – displays all records, where cancellation is set by timestamp: (cancellation != "")

Each of these 3 filter options – seperately performed – works in the expected manner.

But if I try to use the Reservations filter option in an (OR-)relation with the Bookings-filter option  and/or the cancellations-filter option then I always get an empty table instead of my expected data.

So, after a while of intensive testing … I still don't know, what I am doing wrong … or … perhaps … what the grid is doing wrong ;-) .

Thanks in advance for your help and for that fantastic grid!

]]> Tue, 19 Jul 2011 09:10:33 +0300