Group Concat has Problem With Filtering

[haider-pw]

Ok. Just Got Stucked Recently in Problem where Group Concat dont work with Filtering.

Here is the Codeigniter Response

Error Number: 1111

Invalid use of group function

SELECT `E`.`employee_id`, `E`.`full_name`, `MLD`.`designation_name`, GROUP_CONCAT(DISTINCT MLP.project_title) AS Projects, GROUP_CONCAT(DISTINCT MLST.skill_name) AS EmployeeSkills FROM (`emp_skills` ES) INNER JOIN `employee` E ON `E`.`employee_id`= `ES`.`employee_id` INNER JOIN `ml_skill_type` MLST ON `MLST`.`skill_type_id` = `ES`.`ml_skill_type_id` INNER JOIN `employment` ET ON `ET`.`employee_id` = `E`.`employee_id` INNER JOIN `position_management` PM ON `PM`.`employement_id`=`ET`.`employment_id` AND PM.current=1 INNER JOIN `ml_designations` MLD ON `MLD`.`ml_designation_id`=`PM`.`ml_designation_id` LEFT JOIN `assign_job` AJ ON `AJ`.`employee_id` = `E`.`employee_id` LEFT JOIN `ml_projects` MLP ON `MLP`.`project_id` = `AJ`.`project_id` WHERE (E.full_name LIKE '%s%' OR MLD.designation_name LIKE '%s%' OR GROUP_CONCAT(DISTINCT MLP.project_title) LIKE '%s%' OR GROUP_CONCAT(DISTINCT MLST.skill_name) LIKE '%s%' ) GROUP BY `E`.`employee_id` LIMIT 25

Filename: C:\xampp\htdocs\projects\HR\system\database\DB_driver.php

Did any one found any good solution to make filtering work with both GroupConcat fields and Normal Fields.??

Im Using v0.7
https://github.com/pakistanihaider/HouseRentSystem/blob/master/application/libraries/Datatables.php

[haider-pw]

Plus Just Found Out, If used Group_Concat used then pagination and records gets buggy. please Resolve this issue fast...