OroPlatform Forums

Covering OroPlatform topics, including community updates and company announcements.

Forums Forums OroPlatform OroPlatform – Programming Questions Problem with datagrid query

This topic contains 4 replies, has 4 voices, and was last updated by  stalxed 5 years, 9 months ago.

Starting from March 1, 2020 the forum has been switched to the read-only mode. Please head to StackOverflow for support.

  • Creator
  • #33594

    This is my datagrid:

    I receive this error, but I don’t what is the problem that should be related to the doctrine query generated by datagrid:

Viewing 4 replies - 1 through 4 (of 4 total)
  • Author
  • #33595
    Yevhen Shyshkin
    Yevhen Shyshkin

    Hello, @alendo.

    Look’s like the problem is here:

    Your main entity has alias edu_goals, but then you are trying to perform join using alias edu_cloud that in fact is not defined. Probably, it’s a typo – then you simply should use existing alias edu_goals instead of edu_cloud (or vice versa).

    If after you change aliases and make sure that query builder is valid you’ll still have this issue, then you have two options:

    1) you can make you association bidirectional, i.e. each side will know about other side;

    2) you can manually specify join condition using WITH keyword and specify which fields should be used to perform join, here is example.

    If you still have issue after these fixes – please, put here full exception log and entities structure – I’ll try to reproduce it locally.



    Hi alendo,

    I managed to fix some rendering errors using the query monitor from http://YOUR_HOST/app_dev.php/
    You can grab the full sql query and test using your sql client.


    Thank you for your answers, but in the meantime I corrected the error and I experience the same. The problem was that I used orocrm annotation for new entity without add organization field …



    I also spent a lot of times on this bug :(

Viewing 4 replies - 1 through 4 (of 4 total)

The forum ‘OroPlatform – Programming Questions’ is closed to new topics and replies.

You will be redirected to [title]. Would you like to continue?

Yes No