Grouping in the select statement

[bandtank]

I need to use GROUP_CONCAT (or something similar) in a select statement. The following code does not work because GROUP_CONCAT is specified incorrectly, but the idea is conveyed correctly:

    $query = $utils["entityManager"]
      ->getQueryBuilder()
      ->select(array(
        ...
        "GROUP_CONCAT('id')",
      ))
      ->from('Note')
      ->where(array(
        ...
      ))
      ->groupBy("parentType")
      ->build();

I have not been able to figure out how to do this with any aggregating functions. Any help would be greatly appreciated.

[a.slyzhko]

Read this article on how to use complex expressions. You will need to create custom function converter to use group concat.

[bandtank]

Thanks. I will work on this in a few days. it looks like the answer will be a custom class defined in metadata (functionConverterClassNameMap).