filtering a virtual column

Questions › filtering a virtual column

Santosh Pillai asked 7 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 7 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