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?
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.
$col["dbname"] = "table.field";
$col["dbname"] = "concat(table.field1,table.field2)";
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?