Hi,

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.

Steps:

• 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.

https://imgur.com/onvf1sQ

As you see I put the parenthesis and look for “Berk” word and the SQL doesn’t contain the filters on fields.

Any idea¿?

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

Thursday 12h CET is fine. I can also have session on wednesday same time.
You can email any update/confirmation and join google hangouts for quick discussion.

ID: [email protected]