C3media asked 10 years ago
Hi,
I need listing users biy calc text, but looking for filtering show me this error: (Couldn't execute query. Unknown column 'newcol' in 'where clause' – SELECT count(*) as c FROM (SELECT * FROM clients WHERE 1=1 AND `newcol` LIKE '%9%') pg_tmp)
So tried making a view using CONCAT from MySql, and not works. ¿Somebody may to help me with filtering by calc text or anything else function from MySql?
Thanks!
1 Answers
Abu Ghufran answered 10 years ago
Hello,
Calculated columns are non-database fields that are made at application level. Search is not possible by default.
An alternate is to use dbname property that will be replaced in WHERE clause when that column is searched.
e.g.
$col["dbname"] = "table.field";
$col["dbname"] = "concat(table.field1,table.field2)";
Your Answer
