Search on all columns doesn't filter

QuestionsSearch on all columns doesn't filter
Nicolas asked 3 years ago

Hi,

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.

https://gist.github.com/ACTIVA-E/4d1b2e399c1ea53e457d9d2efc3b280a

https://imgur.com/8KA1aQq

Steps to reproduce it is just to search for some word in the “Search all columns” field

Many thanks. Nicolas

5 Answers
Abu Ghufran Staff answered 3 years ago

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.
_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Nicolas answered 3 years ago

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¿?

Abu Ghufran Staff answered 3 years ago

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

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Nicolas answered 3 years ago

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

Abu Ghufran Staff answered 3 years ago

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]

_________________________
Abu Ghufran - Dev Team
Grid 4 PHP Framework
 
Your Answer

12 + 14 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?