jQuery Grid Plugin - jqGridForum

Topic RSS

Trouble with filters

19/07/2011
09:10

TheCore

Member

Members

Forum Posts: 5

Member Since:
03/07/2011

Offline

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!

19/07/2011
11:54

tony

Sofia, Bulgaria

Moderator

Members

Moderators

Forum Posts: 7721

Member Since:
30/10/2007

Offline

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

For professional UI suites for Java Script and PHP visit us at our commercial products site - guriddo.net - by the very same guys that created jqGrid.

19/07/2011
13:58

TheCore

Member

Members

Forum Posts: 5

Member Since:
03/07/2011

Offline

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

21/07/2011
02:32

TheCore

Member

Members

Forum Posts: 5

Member Since:
03/07/2011

Offline

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

All RSS

Forum Timezone: Europe/Sofia

Most Users Ever Online: 715

Currently Online:
52 Guest(s)

Currently Browsing this Page:
1 Guest(s)