Autofilter in column with CONCAT

Questions › Autofilter in column with CONCAT

Juan asked 7 years ago

Is there some way to autofilter in a column grid that contain value of two o more columns in one table

SELECT Id, CONCAT(FirtName,' ',SecondName,', ',Name) person FROM Persons

1 Answers

Abu Ghufran answered 7 years ago

Hi,

Yes you can set this expression in dbname property to be used in WHERE clause.
$col["dbname"] = "CONCAT(FirtName,' ',SecondName,', ',Name)";

Your Answer