⚠ In case you've missed it we are migrating to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This forum is read-only and soon will be archived. ⚠

Search filter issue with extra column

search filter column extra bug jquery ajax

  • Please log in to reply
3 replies to this topic

#1 fredconv



  • Members
  • PipPip
  • 17 posts

Posted 02 October 2012 - 09:03 AM

Topic recreated in correct thread : http://www.grocerycr...h-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 ?



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

#2 mryasir



  • Members
  • Pip
  • 5 posts

Posted 13 July 2013 - 06:01 AM

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,

#3 kannan



  • Members
  • Pip
  • 1 posts

Posted 10 October 2013 - 10:16 AM

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

#4 Amit Shah

Amit Shah

    grocery CRUD Master

  • Advanced Member
  • PipPipPip
  • 1,192 posts

Posted 10 October 2013 - 11:52 AM

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 :)

Also tagged with one or more of these keywords: search, filter, column, extra, bug, jquery, ajax

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users