Problems of filters when use selecte command.

QuestionsProblems of filters when use selecte command.
Sebastián Esteller asked 6 years ago

When use select command in grid filters not works.

Is possible use select command and filters in showed results in grid.


3 Answers
Abu Ghufran answered 6 years ago


Sorry for that but I don't understand the question.
Please explain with some example.

tango answered 5 years ago

Hi Abu,

I faced the same problem also. This is what he meant:

Couldn't execute query. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND title LIKE '%ddf%') pg_tmp' at line 1 – SELECT count(*) as c FROM ( select (select name from option o where = option1_id) name1, g.* from group g AND title LIKE '%ddf%') pg_tmp

The SQL becomes broken when we use select_command and try to do a filter.

Abu Ghufran answered 5 years ago

Hello Tango,

Can you email me grid code file for review (along with db sql) – at [email protected]
I am unable to generate this issue here.

Also tell me which version of lib are you using. (mentioned in lib/inc/jqgrid_dist.php header)

Your Answer

14 + 20 =

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 / 5. Vote count:

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

Let us improve this post!