Doctrine OneToMany related entities are displayed as a single row each instead of one combined row only about zfc-datagrid HOT 18 OPEN

Array
(
    [0] => 95
)

    public function count()
    {
        if ($this->rowCount !== null) {
            return $this->rowCount;
        }

        $q = $this->getQueryBuilder()->getDql();
        $query = $this->getQueryBuilder()->getEntityManager()->createQuery($q);   
        $this->rowCount = count($query);
        return $this->rowCount;
    }

    public function getItems($offset, $itemCountPerPage)
    {       
        $qb = $this->getQueryBuilder();
        $qb->setFirstResult($offset)->setMaxResults($itemCountPerPage);

        $q = "SELECT c, sb, s FROM Application\Entity\Contract c INNER JOIN c.branch b INNER JOIN c.supplierBranch sb INNER JOIN c.integratorBranch ib INNER JOIN c.projectManager pm LEFT JOIN c.items ci INNER JOIN c.states s WHERE c.compartment = 1 AND c.branch = 2 AND c.id = 2 ORDER BY c.number ASC";
        $query = $this->getQueryBuilder()->getEntityManager()->createQuery($q);

        return $query->getArrayResult();
    }

//this is your contract entity
        $col = new Column\Select('description', 'training');
        $col->setLabel('Description');
        $col->setWidth(30);
        $grid->addColumn($col);

//this is your contractItem Entity
        $col = new Column\Select(new Expr\Select('
            (
                SELECT
                    GROUP_CONCAT(
                        hierarchy2.titleShort
                    )
                FROM ...\Entity\Training training2
                JOIN training2.hierarchies hierarchy2
                WHERE
                    training2.id = training.id
            )
        '), 'training_hierarchies');

        $col->setLabel('Hierarchy');
        $col->setWidth(35);
        $grid->addColumn($col);

<?php
namespace User\Entity;

use Zend\Form\Annotation;
use Doctrine\ORM\Mapping as ORM;
use Doctrine\Common\Collections\ArrayCollection;

/**
 * Doctrine ORM implementation of User entity
 * 
 * @ORM\Entity
 * @ORM\Table(name="`user`")
 * @Annotation\Name("User")
 */
class User
{
    /**
     * @var integer
     *
     * @ORM\Column(name="id", type="integer", nullable=false)
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     * @Annotation\Exclude()
     */
    protected $id;

   ...
   ...

    /**
     * @var User\Entity\Role
     * 
     * @ORM\ManyToOne(targetEntity="User\Entity\Role")
     * @ORM\JoinColumn(name="role_id", referencedColumnName="id", nullable=false)
     * @Annotation\Type("DoctrineModule\Form\Element\ObjectSelect")
     * @Annotation\Filter({"name":"StripTags"})
     * @Annotation\Filter({"name":"StringTrim"})
     * @Annotation\Validator({"name":"Digits"})
     * @Annotation\Required(true)
     * @Annotation\Options({
     *   "required":"true",
     *   "empty_option": "Select User Role",
     *   "target_class":"User\Entity\Role",
     *   "property": "name"
     * })
     */
    protected $role;

    /**
     * @var User\Entity\State
     *
     * @ORM\ManyToOne(targetEntity="User\Entity\State")
     * @ORM\JoinColumn(name="state_id", referencedColumnName="id", nullable=false)
     * @Annotation\Type("DoctrineModule\Form\Element\ObjectSelect")
     * @Annotation\Filter({"name":"StripTags"})
     * @Annotation\Filter({"name":"StringTrim"})
     * @Annotation\Validator({"name":"Digits"})
     * @Annotation\Required(true)
     * @Annotation\Options({
     *   "required":"true",
     *   "empty_option": "User State",
     *   "target_class":"User\Entity\State",
     *   "property": "state"
     * })
     */
    protected $state;
    ...
    ...  

        $col = new Column\Select(new \Doctrine\ORM\Query\Expr\Select('
            (
                SELECT
                    GroupConcat(pt2ptgr.name)
                FROM Application\Entity\Contract contract2
                JOIN contract2.items items2
                JOIN items2.parttype pt2
                JOIN pt2.parttypeGroup pt2ptgr
            )
        '), 'contract_items');  

//this is your contract entity
        $col = new Column\Select('name', 'user');
        $col->setLabel('User name');
        $col->setWidth(30);
        $grid->addColumn($col);

//this is your contractItem Entity
        $col = new Column\Select(new Expr\Select('
            (
                SELECT
                    GROUP_CONCAT(
                        state.name
                    )
                FROM ...\Entity\User user2
                JOIN user2.states states2
                WHERE
                    user2.id = user.id
            )
        '), 'user_states');

        $col->setLabel('State');
        $col->setWidth(35);
        $grid->addColumn($col);

<?php
return array(
    'doctrine' => array(
        'connection' => array(
            // default connection name
            'orm_default' => array(
                'driverClass' => 'Doctrine\DBAL\Driver\PDOMySql\Driver',
                'params' => array(
                    'host'     => 'localhost',
                    'port'     => '3306',
                    'user'     => '',
                    'password' => '',
                    'dbname'   => '',
                )
            )
        ),
        // @see http://stackoverflow.com/questions/19120182/how-to-add-a-custom-dql-function-in-doctrine-2-using-zend-framework-2
        'configuration' => array(
            'orm_default' => array(
                'filters' => array(
                ),
                'numeric_functions' => array(
                    'CAST'          => 'DoctrineExtensions\Query\Mysql\Cast',
                    'COUNTIF'       => 'DoctrineExtensions\Query\Mysql\CountIf',
                    'DATE'          => 'DoctrineExtensions\Query\Mysql\Date',
                    'GROUPCONCAT'   => 'DoctrineExtensions\Query\Mysql\GroupConcat',
                    'IFELSE'        => 'DoctrineExtensions\Query\Mysql\IfElse',
                    'WEEK'          => 'DoctrineExtensions\Query\Mysql\Week',
                    'WEEKDAY'       => 'DoctrineExtensions\Query\Mysql\WeekDay',
                    'MONTH'         => 'DoctrineExtensions\Query\Mysql\Month',
                    'YEAR'          => 'DoctrineExtensions\Query\Mysql\Year',
                    'STRTODATE'     => 'DoctrineExtensions\Query\Mysql\StrToDate',
                    'TIMEDIFF'      => 'DoctrineExtensions\Query\Mysql\Timediff',
                    'TIMETOSEC'     => 'DoctrineExtensions\Query\Mysql\TimeToSec',
                ),
                'datetime_functions' => array(),
                'string_functions'   => array(),
            )
        ),
        'eventmanager' => array(
            'orm_default' => array(
                'subscribers' => array(
                    // pick any listeners you need
                    'Gedmo\Timestampable\TimestampableListener',
                ),
            ),
        ),
    ),
);

    GroupConcat(Role.name, Role.id)