filtering a virtual column

Questions › filtering a virtual column
0 Vote Up Vote Down
Santosh Pillai asked 8 years ago

Hi Abu,
Is it possible to filter a virtual field? I am able to sort using the solution in the post below
http://support.gridphp.com/questions/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
0 Vote Up Vote Down
Cedric answered 8 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

13 + 15 =

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?