AssalamOAlaikum Abu Ghufran,
I am using the paid version of PHPGrid and finding it difficult to filter the grid with the correct results based on 3 fields.
There are 2 fields A and B. A is of Type varchar and B is int, what I am doing is:
Values for field A = Apple, Mango, Banana, Cherry
Values for field B = 100, 200, 300
1) Apple, 200
2) Apple, 300
3) Mango, 100
4) Mango, 300
Search type "any"
A contains "apple"
A contains "mango"
B greater than or equal 200
What it does, it returns all the records which are greater than 200 without filtering field A on the given criteria. When i tried filtering/searching without field B, it returned the correct results.
(PS: I am using field A twice in the search)
Looking forward to get an advice.
Currently, it is applying ORing on all conditions. And if 3rd condition is met rest are ignored.
I guess, what you need is (a=='apple'||a=='mango') AND (b>200)
For such case, emailing you demo and updated lib (lib/inc folder).
How useful was this discussion?
Click on a star to rate it!
Average rating / 5. Vote count:
We are sorry that this post was not useful for you!
Let us improve this post!
Thanks for your feedback!