Error filtering Calc Text

QuestionsError filtering Calc Text
C3media asked 7 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 7 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

8 + 5 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?