The main filter of the grid doesn’t filter. While typing something, the screen flicks al little but rows doesn’t filter. I suppose there is something wrong in the code, but I have no idea how to debug that.
I join the code and a screenshot.
Steps to reproduce it is just to search for some word in the “Search all columns” field
Many thanks. Nicolas
I reviewed your code and all looks ok. You can try putting the where conditions in parenthesis ( )
$g->select_command = “Select ev_address.*, ev_who_customer.own From ev_who_customer Inner Join ev_address On ev_who_customer.id_customer = ev_address.id_customer Where (ev_address.deleted=0 And ev_who_customer.username ='”.$_SESSION[‘name’].”‘)”
Same applies for other sql in select_command.
If this does not solve, you can debug the sql query for search and update back.
- Open grid in browser
- Go to code and add $g->debug_sql = true;
- Go to browser and try search
- It will show the query being executed in debug box.
Thank you Abu, but it doesn’t work. I put all Where conditions within parenthesis and including remove them completely from the main query and all dropdown columns, but no way.
I set to debug and it seems that the query is not updated with the search field content.
I put you a screenshot.
As you see I put the parenthesis and look for “Berk” word and the SQL doesn’t contain the filters on fields.
I’m not getting the issue. We can have remote session to check it further.
Please let me know your working hours, time zone and feasible time to connect.
Also set up: https://remotedesktop.google.com/support
Hi Abu, ok
I’m in Spain, Central European Time, GMT+2h
And how about you?
Can we try around 6pm tomorrow (wednesday) or thursday from 10h to 18h
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?