filtering a virtual column

Questionsfiltering a virtual column
Santosh Pillai asked 2 years 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
Error

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

 

1 Answers
Cedric answered 2 years 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 + 19 =

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?