
On t.Id = y.tickets_id and y.is_private = 1 and y.state = 0 and y.content REGEXP "Escalade" AND y.content REGEXP "SVP|Administration" and users_id_tech = 0 T.solve_delay_stat "Délai de résolution", GROUP_CONCAT(DISTINCT concat(uz.realname,' ',uz.firstname) SEPARATOR ',') AS "Demandeur FIDAL",Ĭoalesce(s.satisfaction, '0') as Satisfaction,Ĭount(w.tickets_id_1) as "Nombre de ticket dupliqués", T.takeintoaccount_delay_stat as "Délai de prise en compte", T.due_date as "Date d'échéance + Progression", GROUP_CONCAT(DISTINCT concat(uv.realname,' ',uv.firstname) SEPARATOR ',') AS Technicien,


GROUP_CONCAT(DISTINCT concat(us.realname,' ',us.firstname) SEPARATOR ',') AS "Bénéficiaire FIDAL", I don't understand why this sql request generate a malfonction when I activate the refined search function inside my grid.
