Add custom contact field to marketing list

I have a custom contact field that is a many to one. When creating a marketing list it does not display as field.

How can I add it?

Topic

[Mike KudelyaParticipant]

Hi,

Unfortunately for now we don’t have opportunity to add relation fields to marketing list.

[apciminoParticipant]

Any suggested work arounds? We can turn this field into account names. Will that allow us to export the marketing list with the account name plus the contact fields?

[Mike KudelyaParticipant]

Hi,

Here is example how you can add phone number of call entity (in my case) in lead marketing list:

Listener:

PHP

<?php namespace Custom\Bundle\OroBundle\EventListener; use Oro\Bundle\DataGridBundle\Datagrid\Common\DatagridConfiguration; use Oro\Bundle\DataGridBundle\Datagrid\ParameterBag; use Oro\Bundle\DataGridBundle\Event\PreBuild; use OroCRM\Bundle\MarketingListBundle\Datagrid\ConfigurationProvider; class MarketingGridListener { const FROM_PATH = '[source][query][from]'; const SELECT_PATH = '[source][query][select]'; const COLUMNS_PATH = '[columns]'; const JOIN_PATH = '[source][query][join][left]'; const MAIN_ENTITY = 'OroCRM\\Bundle\\SalesBundle\\Entity\\Lead'; const RELATED_ENTITY = 'callentity'; const RELATED_ENTITY_FIELD_NAME = 'phoneNumber'; /** * @param PreBuild $event */ public function onBuildBefore(PreBuild $event) { $this->applyFilters($event->getConfig(), $event->getParameters()); } /** * @param DatagridConfiguration $config * @param ParameterBag $parameters */ protected function applyFilters(DatagridConfiguration $config, ParameterBag $parameters) { $isValid = $config->offsetExistByPath(self::FROM_PATH) && strpos($config->offsetGet('name'), ConfigurationProvider::GRID_PREFIX) !== false; if ($isValid) { $from = $config->offsetGetByPath(self::FROM_PATH); if ($from[0]['table'] === self::MAIN_ENTITY) { $joinColumn = $from[0]['alias'] . '.' . self::RELATED_ENTITY; $entityJoin = [ ['join' => $joinColumn, 'alias' => 'relation_entity'] ]; $selects = $config->offsetGetByPath(self::SELECT_PATH, array()); $selects[] = 'relation_entity.' . self::RELATED_ENTITY_FIELD_NAME; $config->offsetSetByPath(self::SELECT_PATH, $selects); $columns = $config->offsetGetByPath(self::COLUMNS_PATH, array()); $columns['phoneNumber'] = array('label' => 'phone number'); $config->offsetSetByPath(self::COLUMNS_PATH, $columns); $config->offsetAddToArrayByPath(self::JOIN_PATH, $entityJoin); } } } }

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 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62

<?php   namespace Custom\Bundle\OroBundle\EventListener;   use Oro\Bundle\DataGridBundle\Datagrid\Common\DatagridConfiguration; use Oro\Bundle\DataGridBundle\Datagrid\ParameterBag; use Oro\Bundle\DataGridBundle\Event\PreBuild;   use OroCRM\Bundle\MarketingListBundle\Datagrid\ConfigurationProvider;   class MarketingGridListener {     const FROM_PATH = '[source][query][from]';     const SELECT_PATH = '[source][query][select]';     const COLUMNS_PATH = '[columns]';     const JOIN_PATH = '[source][query][join][left]';       const MAIN_ENTITY = 'OroCRM\\Bundle\\SalesBundle\\Entity\\Lead';     const RELATED_ENTITY = 'callentity';     const RELATED_ENTITY_FIELD_NAME = 'phoneNumber';       /**      * @param PreBuild $event      */     public function onBuildBefore(PreBuild $event)     {         $this->applyFilters($event->getConfig(), $event->getParameters());     }       /**      * @param DatagridConfiguration $config      * @param ParameterBag $parameters      */     protected function applyFilters(DatagridConfiguration $config, ParameterBag $parameters)     {         $isValid =             $config->offsetExistByPath(self::FROM_PATH) &&             strpos($config->offsetGet('name'), ConfigurationProvider::GRID_PREFIX) !== false;           if ($isValid) {               $from = $config->offsetGetByPath(self::FROM_PATH);               if ($from[0]['table'] === self::MAIN_ENTITY) {                 $joinColumn = $from[0]['alias'] . '.' . self::RELATED_ENTITY;                 $entityJoin = [                     ['join' => $joinColumn, 'alias' => 'relation_entity']                 ];                   $selects = $config->offsetGetByPath(self::SELECT_PATH, array());                 $selects[] = 'relation_entity.' . self::RELATED_ENTITY_FIELD_NAME;                 $config->offsetSetByPath(self::SELECT_PATH, $selects);                   $columns = $config->offsetGetByPath(self::COLUMNS_PATH, array());                 $columns['phoneNumber'] = array('label' => 'phone number');                 $config->offsetSetByPath(self::COLUMNS_PATH, $columns);                   $config->offsetAddToArrayByPath(self::JOIN_PATH, $entityJoin);             }         }         } }

Define the listener in services.yml:

YAML

parameters: custom_oro.listener.datagrid.marketing_list.class: Custom\Bundle\OroBundle\EventListener\MarketingGridListener services: custom_oro.listener.datagrid.marketing_list: class: %custom_oro.listener.datagrid.marketing_list.class% tags: - { name: kernel.event_listener, event: oro_datagrid.datagrid.build.pre, method: onBuildBefore }

1 2 3 4 5 6 7 8

parameters:     custom_oro.listener.datagrid.marketing_list.class: Custom\Bundle\OroBundle\EventListener\MarketingGridListener   services:     custom_oro.listener.datagrid.marketing_list:         class: %custom_oro.listener.datagrid.marketing_list.class%         tags:             - { name: kernel.event_listener, event: oro_datagrid.datagrid.build.pre, method: onBuildBefore }

[Author]

Replies