[fredconv]

Hi
Topic recreated in correct thread : /topic/949-search-filter-issue-with-extra-column/


Quote here :
In my grid from table "projects"
I ve got a project, a code, a priority, and I ve added an extra column "desired actions" that is not in the table "projects"

when i try to make a search on all fields, I got a sql error:
Unknown column 'desired actions' in 'where clause'..
I even tried with a "desired_actions" column name but this doesn't work for me. it seems since this is not a column from the table, it should be excluded from the where clause.

if i search for a specific column, then it works.

Any way to fix or avoid this ?

Thanks

Fred

EDIT : I post this in the wrong thread, this should have been in the bug/issue thread. but i don t know how to move it sorry ..

[mryasir]

This library is very useful, thanks for this ...
I am also facing the same issue, with searching and sorting problem with extra fields.

 

Sorting and searching on call back column (alias column) makes database error, unknow column

Please answer any body,

[kannan]

generally grocery crud will work on single table basis. so watever columns you have added through call back column, the columns are not searchable one..

[Amit Shah]

Well this is a known bug and yet to be patched for the release but for time being a solution is provided - here

 

Happy GCing :)