Jump to content

Search filter issue with extra column

search extra column filter where sql

  • Please log in to reply
No replies to this topic

#1 fredconv



  • Members
  • PipPip
  • 17 posts

Posted 02 October 2012 - 11:30 AM


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 ?



Also tagged with one or more of these keywords: search, extra, column, filter, where, sql

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users