title: mysql | Getting Database error, Invalid Use of Group Function
body: <p>i am using ignited datatables. it is working fine except for the filter. when i do searching in it, i get error</p>
  
  <blockquote>
    <p>Invalid Use of group function</p>
  </blockquote>
  
  <p>i am getting this query in error result.</p>
  
  <pre><code>SELECT `f`.`FormID`, `f`.`FormName`, `f`.`FormCIPath`, 
  MIN(g.IsMenuLink) AS IsMenuLink, 
  GROUP_CONCAT(DISTINCT g.GroupID ORDER BY g.GroupID) AS GroupIDs 
  FROM (`sys_forms` f) INNER JOIN `sys_forms_in_groups` g ON `g`.`FormID` = `f`.`FormID` 
  WHERE `g`.`GroupID` IN ('1', '1') AND (UPPER(f.FormName) LIKE '%DA%' OR 
  UPPER(f.FormCIPath) LIKE '%DA%' OR UPPER(MIN(g.IsMenuLink)) LIKE '%DA%' ) 
  GROUP BY `f`.`formID` LIMIT 25
  </code></pre>
  
  <p>what is wrong with the query.?? </p>