Cannot access custom field in datagrid

Hi all,

I have an issue which has me completely stumped. I have an extended entity which I added a field to via a migration:

PHP

protected function createCentresContactsRelation(Schema $schema) { $this->extendExtension->addManyToManyRelation( $schema, 'k8_centre', // owning side table 'contacts', // owning side field name 'orocrm_contact', // target side table ["first_name", "last_name"], // column names are used to show a title of related entity ["first_name", "last_name"], // column names are used to show detailed info about related entity ["first_name", "last_name"], // Column names are used to show related entity in a grid [] ); $this->extendExtension->addManyToManyInverseRelation( $schema, 'k8_centre', // owning side table 'contacts', // owning side field name 'orocrm_contact', // target side table 'centres', // target side field name ["first_name", "last_name"], // column names are used to show a title of related entity ["first_name", "last_name"], // column names are used to show detailed info about related entity ["first_name", "last_name"], // Column names are used to show related entity in a grid [] ); }

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

protected function createCentresContactsRelation(Schema $schema)     {         $this->extendExtension->addManyToManyRelation(             $schema,             'k8_centre', // owning side table             'contacts', // owning side field name             'orocrm_contact', // target side table             ["first_name", "last_name"], // column names are used to show a title of related entity             ["first_name", "last_name"], // column names are used to show detailed info about related entity             ["first_name", "last_name"], // Column names are used to show related entity in a grid             []         );         $this->extendExtension->addManyToManyInverseRelation(             $schema,             'k8_centre', // owning side table             'contacts', // owning side field name             'orocrm_contact', // target side table             'centres', // target side field name             ["first_name", "last_name"], // column names are used to show a title of related entity             ["first_name", "last_name"], // column names are used to show detailed info about related entity             ["first_name", "last_name"], // Column names are used to show related entity in a grid             []         );     }

This is how the entity’s relations array now looks if use run oro:entity-config:debug:

Shell

[relation] => Array ( [manyToMany|K8\Bundle\CentreBundle\Entity\Centre|OroCRM\Bundle\ContactBundle\Entity\Contact|contacts] => Array ( [target_field_id] => Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId Object ( [scope:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => extend [className:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => OroCRM\Bundle\ContactBundle\Entity\Contact [fieldName:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => centres [fieldType:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => manyToMany ) ) )

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

[relation] => Array                 (                     [manyToMany|K8\Bundle\CentreBundle\Entity\Centre|OroCRM\Bundle\ContactBundle\Entity\Contact|contacts] => Array                         (                             [target_field_id] => Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId Object                                 (                                     [scope:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => extend                                     [className:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => OroCRM\Bundle\ContactBundle\Entity\Contact                                     [fieldName:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => centres                                     [fieldType:Oro\Bundle\EntityConfigBundle\Config\Id\FieldConfigId:private] => manyToMany                                 )                           )                   )

I am now trying to retrieve this relation in the datagrid:

YAML

k8-centre-contacts-select-grid: extended_entity_name: %k8.centre.class% options: entityHint: centre acl_resource: k8_centre_view source: type: orm query: select: - centre.contacts - contact.id - contact.firstName - contact.lastName from: - { table: %k8.centre.class%, alias: centre } join: left: - { join: centre.contacts, alias: contact } where: and: - contact.id in centre.contacts

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

k8-centre-contacts-select-grid:         extended_entity_name: %k8.centre.class%         options:             entityHint: centre         acl_resource: k8_centre_view         source:             type: orm             query:                 select:                     - centre.contacts                     - contact.id                     - contact.firstName                     - contact.lastName                 from:                     - { table: %k8.centre.class%, alias: centre }                 join:                     left:                         - { join: centre.contacts, alias: contact }                 where:                     and:                         - contact.id in centre.contacts

But I am receiving the following error:

An exception has been thrown during the rendering of a template (“No mapping found for field ‘contacts’ on class ‘K8\Bundle\CentreBundle\Entity\Centre’.”) in OroDataGridBundle:Grid/widget:widget.html.twig at line 11.

Where am I going wrong here? Thanks in advance!

Miles

Topic

[Mike KudelyaParticipant]

Hi

You can use extended fields on grid only if you can’t remove them from UI. Try to mark our field as read only:

PHP

$this->extendExtension->addManyToManyRelation( $schema, 'orocrm_call', // owning side table 'contacts', // owning side field name 'orocrm_contact', // target side table ["first_name", "last_name"], // column names are used to show a title of related entity ["first_name", "last_name"], // column names are used to show detailed info about related entity ["first_name", "last_name"], // Column names are used to show related entity in a grid [ ExtendOptionsManager::MODE_OPTION => ConfigModel::MODE_READONLY, 'extend' => [ 'owner' => ExtendScope::OWNER_CUSTOM, 'is_extend' => true ] ] );

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

$this->extendExtension->addManyToManyRelation(             $schema,             'orocrm_call', // owning side table             'contacts', // owning side field name             'orocrm_contact', // target side table             ["first_name", "last_name"], // column names are used to show a title of related entity             ["first_name", "last_name"], // column names are used to show detailed info about related entity             ["first_name", "last_name"], // Column names are used to show related entity in a grid             [                 ExtendOptionsManager::MODE_OPTION => ConfigModel::MODE_READONLY,                 'extend' => [                     'owner' => ExtendScope::OWNER_CUSTOM,                     'is_extend' => true                 ]             ]         );

[quuuaidParticipant]

Thanks Mike! I’ll give that a try. Actually this prompted me to grep the crm repo for MODE_READONLY which revealed a nice example of passing additional parameters in https://github.com/orocrm/crm/blob/master/src/Oro/Bundle/ChannelBundle/Migrations/Schema/OroChannelBundleInstaller.php#L310. It would be great if these options were documented in more detail as both the docs and nearly all the examples within the platform and crm repos only demonstrate the use of the ‘owner’ key.

[Mike KudelyaParticipant]

We will consider it, thanks

[Author]

Replies