Jump to content


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

fredconv

    Member

  • Members
  • PipPip
  • 17 posts

Posted 02 October 2012 - 09:03 AM

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

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

#2 mryasir

mryasir

    Newbie

  • 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

kannan

    Newbie

  • 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
  • LocationMumbai, India

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