filtering a virtual column

Questionsfiltering a virtual column
Santosh Pillai asked 1 year ago

Hi Abu,
Is it possible to filter a virtual field? I am able to sort using the solution in the post below

Sorting a Virtual Field – is it possible

Is it possible to specify a field for filtering in a similar way?
Currently I am seeing error as fieldNamex is a based on a subquery

Couldn’t execute query. Unknown column ‘fieldNamex’ in ‘where clause’ 


1 Answers
Cedric answered 1 year ago

Hi, You should add this:
$col[“dbname”] = “yourfieldname”;
and the field name used there must be present in your SQL query

Your Answer

20 + 9 =

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 / 5. Vote count:

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

Let us improve this post!