How to write a dql query?

Question

symfony

Hello!
I'm working on filters in the current project. There is such a structure.

In the view there should be a list of option.name and its possible properties:

<ul>
    {% for option in options %}

        <li> {{ option.name }}
            <ul>
        {% for value in option.productsOptionValues  %}
            <li>
                <input type="checkbox" value="{{ value.value }}" name="filter[{{ option.name }}][{{ value.id }}]" {% if filter[option.name][value.id] is defined %} checked="checked" {% endif %} />
                {{ value.value }}
            </li>
        {% endfor %}
            </ul>
        </li>
    {% endfor %}
    </ul>

Here's a visual:

I understand that you can get both the option and its distinct values ​​in one request. But I've been trying to do this for over an hour now and it just doesn't work. Actually what request in this case will be correct?

Answer 1

This can be done without dql:

$options = $this->getDoctrine()
      ->getRepository('AppBundle:Option')
      ->createQueryBuilder('o')
      ->select('o, v')
      ->join('o.values', 'v')
      ->getQuery()
      ->getResult();