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 6 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 6 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

2 + 15 =

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?