title: GORM / HQL - LISTAGG
body: <p>in GORM (using grails) i need to combine in subselect multiple results into one value. (result of this subselect will be concatenated value on which i can make search / sort etc. ...)
  Query is writen as HQL. Something like this in oracle
  <a href="http://www.techonthenet.com/oracle/functions/listagg.php" rel="nofollow">http://www.techonthenet.com/oracle/functions/listagg.php</a></p>
  
  <p>Can be something like that achieved in HQL (e.g. GORM) ?</p>
  
  <pre><code>...
  AND (
      SELECT LISTAG(e.title) AS con FROM Entity e
      WHERE Entity.searchKey = TRUE
      AND e.parrent = par
      AND LOWER(e.title) LIKE :search
  ) &gt; 0
  ...
  ORDER BY con ASC
  </code></pre>
  
  <p>thansk</p>