Problem with datagrid query

This is my datagrid:

educacloud_edu_goals_grid: extended_entity_name: %educa_cloud_edu_goals.entity.class% source: acl_resource: educacloud_acl_edu_goals_view type: orm query: select: - edu_goals.description - edu_goals.code - edu_context.label as contextLabel - edu_group.label as groupLabel from: - { table: %educa_cloud_edu_goals.entity.class%, alias: edu_goals } join: left: - { join: edu_cloud.context, alias: edu_context } - { join: edu_cloud.group, alias: edu_group } columns: description: label: educa_cloud.base_tables.description.label code: label: educa_cloud.base_tables.code.label contextLabel: label: educa_cloud.base_tables.edu_context.label groupLabel: label: educa_cloud.base_tables.edu_group.label ...

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

educacloud_edu_goals_grid:         extended_entity_name: %educa_cloud_edu_goals.entity.class%         source:             acl_resource: educacloud_acl_edu_goals_view             type: orm             query:                 select:                     - edu_goals.description                     - edu_goals.code                     - edu_context.label as contextLabel                     - edu_group.label as groupLabel                 from:                     - { table: %educa_cloud_edu_goals.entity.class%, alias: edu_goals }                 join:                     left:                     - { join: edu_cloud.context, alias: edu_context }                     - { join: edu_cloud.group, alias: edu_group }         columns:             description:                 label:  educa_cloud.base_tables.description.label             code:                 label:  educa_cloud.base_tables.code.label             contextLabel:                 label:  educa_cloud.base_tables.edu_context.label             groupLabel:                 label:  educa_cloud.base_tables.edu_group.label ...

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

An exception has been thrown during the rendering of a template ("A single-valued association path expression to an inverse side is not supported in DQL queries. Use an explicit join instead.") in /Users/ale/Sites/crm-application/vendor/oro/platform/src/Oro/Bundle/UIBundle/Resources/views/actions/index.html.twig at line 33.

1 2 3 4 5

An exception has been thrown during the rendering of a template ("A single-valued association path expression to an inverse side is not supported in DQL queries. Use an explicit join instead.") in /Users/ale/Sites/crm-application/vendor/oro/platform/src/Oro/Bundle/UIBundle/Resources/views/actions/index.html.twig at line 33.

Topic

[Yevhen ShyshkinParticipant]

Hello, @alendo.

Look’s like the problem is here:

from: - { table: %educa_cloud_edu_goals.entity.class%, alias: edu_goals } join: left: - { join: edu_cloud.context, alias: edu_context } - { join: edu_cloud.group, alias: edu_group }

1 2 3 4 5 6

from:     - { table: %educa_cloud_edu_goals.entity.class%, alias: edu_goals } join:     left:     - { join: edu_cloud.context, alias: edu_context }     - { join: edu_cloud.group, alias: edu_group }

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.

[RodolfoParticipant]

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.

[alendoParticipant]

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 …

* @Config( * defaultValues={ ... * "ownership"={ * "owner_type"="BUSINESS_UNIT", * "owner_field_name"="owner", * "owner_column_name"="business_unit_owner_id", * "organization_field_name"="organization", * "organization_column_name"="organization_id" * }, ...

1 2 3 4 5 6 7 8 9 10 11 12 13

* @Config( *      defaultValues={ ... *          "ownership"={ *              "owner_type"="BUSINESS_UNIT", *              "owner_field_name"="owner", *              "owner_column_name"="business_unit_owner_id", *              "organization_field_name"="organization", *              "organization_column_name"="organization_id" *          }, ...

[stalxedParticipant]

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

[Author]

Replies