search

oroinc / platform

Main OroPlatform package with core functionality.
Other
628 stars 351 forks source link

Grid hydration problem in 2.0 #636

Open jneto81 opened 7 years ago

jneto81 commented 7 years ago

In version 2, I have a extra query for each grid row. Do I need to update my grids configuration?

mbessolov commented 7 years ago

@jneto81 what kind of query?

jneto81 commented 7 years ago

For example, with the users grid, for each row of the grid,

SELECT t0.phone AS phone_1, t0.title AS title_2, t0.googleId AS googleId_3, t0.serialized_data AS serialized_data_4, t0.id AS id_5, t0.username AS username_6, t0.email AS email_7, t0.name_prefix AS name_prefix_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.name_suffix AS name_suffix_12, t0.birthday AS birthday_13, t0.enabled AS enabled_14, t0.last_login AS last_login_15, t0.createdAt AS createdAt_16, t0.updatedAt AS updatedAt_17, t0.password AS password_18, t0.salt AS salt_19, t0.login_count AS login_count_20, t0.confirmation_token AS confirmation_token_21, t0.password_requested AS password_requested_22, t0.password_changed AS password_changed_23, t0.business_unit_owner_id AS business_unit_owner_id_24, t0.status_id AS status_id_25, t0.organization_id AS organization_id_26, t0.avatar_id AS avatar_id_27, t0.auth_status_id AS auth_status_id_28 FROM oro_user t0 WHERE t0.id = ? Parameters: [2]

SELECT t0.phone AS phone_1, t0.title AS title_2, t0.googleId AS googleId_3, t0.serialized_data AS serialized_data_4, t0.id AS id_5, t0.username AS username_6, t0.email AS email_7, t0.name_prefix AS name_prefix_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.name_suffix AS name_suffix_12, t0.birthday AS birthday_13, t0.enabled AS enabled_14, t0.last_login AS last_login_15, t0.createdAt AS createdAt_16, t0.updatedAt AS updatedAt_17, t0.password AS password_18, t0.salt AS salt_19, t0.login_count AS login_count_20, t0.confirmation_token AS confirmation_token_21, t0.password_requested AS password_requested_22, t0.password_changed AS password_changed_23, t0.business_unit_owner_id AS business_unit_owner_id_24, t0.status_id AS status_id_25, t0.organization_id AS organization_id_26, t0.avatar_id AS avatar_id_27, t0.auth_status_id AS auth_status_id_28 FROM oro_user t0 WHERE t0.id = ? Parameters: [3]

mkudelya commented 7 years ago

Hi @jneto81

It is known issue, we will fix it as soon as possible according with priorities. Thank you for your patience.

jneto81 commented 7 years ago

Any news about this ?

jneto81 commented 5 years ago

It looks the problem is in the file /vendor/oro/platform/src/Oro/Bundle/DataGridBundle/Extension/Formatter/FormatterExtension.php

with the call of visitResult(DatagridConfiguration using $properties['action_configuration']