See doctrine query builder DQL with params inplace

Question

Is there any chance to get DQL query from doctrine Query Builder object with all param inplace of markers?

Couse $query->getDQL() will return query but with params markers instead of real values, even after they have been set by setParameter function.

Answer 1

You can get the parameters with $query->getParameters()

print_r(array(
    'dql' => $query->getDQL(),
    'parameters' => $query->getParameters(),
));