Adding jobtitle to contact datagrid

Hello,

I trying to customize data grid of contacts list, I remove some columns, add account name column without any problem.

But when I’m trying add simple default column without relation – jobTitle I get problems with DQL, what I’m doing wrong?

datagrid:

contacts-grid: extended_entity_name: %orocrm_contact.entity.class% source: type: orm acl_resource: orocrm_contact_view query: select: - c.id - c.firstName - c.lastName - c.createdAt - c.updatedAt # - с.jobTitle - account.name as organizationName - contactSource.label as contactSourceLabel - email.email as primaryEmail - phone.phone as primaryPhone - CONCAT(CASE WHEN address.regionText IS NOT NULL THEN address.regionText ELSE region.name END, '') as regionLabel - country.name as countryName - address.postalCode as addressPostalCode from: - { table: %orocrm_contact.entity.class%, alias: c } join: left: - { join: c.addresses, alias: address, conditionType: WITH, condition: 'address.primary = true' } - { join: c.emails, alias: email, conditionType: WITH, condition: 'email.primary = true' } - { join: c.phones, alias: phone, conditionType: WITH, condition: 'phone.primary = true' } - { join: c.source, alias: contactSource } - { join: address.country, alias: country } - { join: address.region, alias: region } - { join: c.accounts, alias: account } hints: - { name: HINT_CUSTOM_OUTPUT_WALKER, value: %oro_translation.translation_walker.class%} columns: firstName: label: orocrm.contact.first_name.label lastName: label: orocrm.contact.last_name.label # jobTitle: # label: orocrm.contact.job_title.label primaryEmail: label: orocrm.contact.email.label primaryPhone: label: orocrm.contact.contactphone.phone.label frontend_type: phone contactSourceLabel: label: orocrm.contact.source.label countryName: label: orocrm.contact.contactaddress.country.label regionLabel: label: orocrm.contact.contactaddress.region.label addressPostalCode: label: orocrm.contact.contactaddress.postal_code.label createdAt: label: oro.ui.created_at frontend_type: datetime updatedAt: label: oro.ui.updated_at frontend_type: datetime organizationName: label: orocrm.account.name.label properties: id: ~ view_link: type: url route: orocrm_contact_view params: [ id ] update_link: type: url route: orocrm_contact_update params: [ id ] delete_link: type: url route: oro_api_delete_contact params: [ id ] sorters: columns: firstName: data_name: c.firstName lastName: data_name: c.lastName primaryEmail: data_name: email.email primaryPhone: data_name: phone.phone contactSourceLabel: data_name: contactSource.label countryName: data_name: country.name regionLabel: data_name: regionLabel addressPostalCode: data_name: address.postalCode createdAt: data_name: c.createdAt updatedAt: data_name: c.updatedAt organizationName: data_name: account.name default: lastName: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC firstName: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC filters: columns: firstName: type: string data_name: c.firstName lastName: type: string data_name: c.lastName primaryEmail: type: string data_name: email.email primaryPhone: type: string data_name: phone.phone contactSourceLabel: type: entity data_name: contactSource.name enabled: false options: field_options: class: OroCRMContactBundle:Source property: label countryName: type: entity data_name: address.country enabled: false options: field_options: class: OroAddressBundle:Country property: name query_builder: @orocrm_contact.contact.datagrid_helper->getCountryFilterQueryBuilder regionLabel: type: string data_name: regionLabel enabled: false addressPostalCode: type: string data_name: addressPostalCode enabled: false createdAt: type: datetime data_name: c.createdAt updatedAt: type: datetime data_name: c.updatedAt enabled: false actions: view: type: navigate acl_resource: orocrm_contact_view label: oro.grid.action.view icon: eye-open link: view_link rowAction: true update: type: navigate acl_resource: orocrm_contact_update label: oro.grid.action.update icon: edit link: update_link delete: type: delete acl_resource: orocrm_contact_delete label: oro.grid.action.delete icon: trash link: delete_link mass_actions: delete: type: delete entity_name: %orocrm_contact.entity.class% data_identifier: c.id acl_resource: orocrm_contact_delete label: oro.grid.action.delete icon: trash options: entityHint: contact export: true

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 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181

contacts-grid:         extended_entity_name: %orocrm_contact.entity.class%         source:             type: orm             acl_resource: orocrm_contact_view             query:                 select:                     - c.id                     - c.firstName                     - c.lastName                     - c.createdAt                     - c.updatedAt                     # - с.jobTitle                     - account.name as organizationName                     - contactSource.label as contactSourceLabel                     - email.email as primaryEmail                     - phone.phone as primaryPhone                     - CONCAT(CASE WHEN address.regionText IS NOT NULL THEN address.regionText ELSE region.name END, '') as regionLabel                     - country.name as countryName                     - address.postalCode as addressPostalCode                 from:                     - { table: %orocrm_contact.entity.class%, alias: c }                 join:                     left:                         - { join: c.addresses, alias: address, conditionType: WITH, condition: 'address.primary = true' }                         - { join: c.emails, alias: email, conditionType: WITH, condition: 'email.primary = true' }                         - { join: c.phones, alias: phone, conditionType: WITH, condition: 'phone.primary = true' }                         - { join: c.source, alias: contactSource }                         - { join: address.country, alias: country }                         - { join: address.region, alias: region }                         - { join: c.accounts, alias: account }             hints:                 - { name: HINT_CUSTOM_OUTPUT_WALKER, value: %oro_translation.translation_walker.class%}         columns:             firstName:                 label:         orocrm.contact.first_name.label             lastName:                 label:         orocrm.contact.last_name.label             # jobTitle:             #     label:         orocrm.contact.job_title.label             primaryEmail:                 label:         orocrm.contact.email.label             primaryPhone:                 label:         orocrm.contact.contactphone.phone.label                 frontend_type: phone             contactSourceLabel:                 label:         orocrm.contact.source.label             countryName:                 label:         orocrm.contact.contactaddress.country.label             regionLabel:                 label:         orocrm.contact.contactaddress.region.label             addressPostalCode:                 label:         orocrm.contact.contactaddress.postal_code.label             createdAt:                 label:         oro.ui.created_at                 frontend_type: datetime             updatedAt:                 label:         oro.ui.updated_at                 frontend_type: datetime             organizationName:                 label:         orocrm.account.name.label         properties:             id: ~             view_link:                 type:       url                 route:      orocrm_contact_view                 params:     [ id ]             update_link:                 type:       url                 route:      orocrm_contact_update                 params:     [ id ]             delete_link:                 type:       url                 route:      oro_api_delete_contact                 params:     [ id ]         sorters:             columns:                 firstName:                     data_name: c.firstName                 lastName:                     data_name: c.lastName                 primaryEmail:                     data_name: email.email                 primaryPhone:                     data_name: phone.phone                 contactSourceLabel:                     data_name: contactSource.label                 countryName:                     data_name: country.name                 regionLabel:                     data_name: regionLabel                 addressPostalCode:                     data_name: address.postalCode                 createdAt:                     data_name: c.createdAt                 updatedAt:                     data_name: c.updatedAt                 organizationName:                     data_name: account.name             default:                 lastName:  %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC                 firstName: %oro_datagrid.extension.orm_sorter.class%::DIRECTION_ASC         filters:             columns:                 firstName:                     type: string                     data_name: c.firstName                 lastName:                     type: string                     data_name: c.lastName                 primaryEmail:                     type: string                     data_name: email.email                 primaryPhone:                     type: string                     data_name: phone.phone                 contactSourceLabel:                     type: entity                     data_name: contactSource.name                     enabled: false                     options:                         field_options:                             class: OroCRMContactBundle:Source                             property: label                 countryName:                     type: entity                     data_name: address.country                     enabled: false                     options:                         field_options:                           class: OroAddressBundle:Country                           property: name                           query_builder: @orocrm_contact.contact.datagrid_helper->getCountryFilterQueryBuilder                 regionLabel:                     type: string                     data_name: regionLabel                     enabled: false                 addressPostalCode:                     type: string                     data_name: addressPostalCode                     enabled: false                 createdAt:                     type:      datetime                     data_name: c.createdAt                 updatedAt:                     type:      datetime                     data_name: c.updatedAt                     enabled: false         actions:             view:                 type: navigate                 acl_resource: orocrm_contact_view                 label: oro.grid.action.view                 icon: eye-open                 link: view_link                 rowAction: true             update:                 type: navigate                 acl_resource: orocrm_contact_update                 label: oro.grid.action.update                 icon: edit                 link: update_link             delete:                 type: delete                 acl_resource: orocrm_contact_delete                 label: oro.grid.action.delete                 icon: trash                 link: delete_link         mass_actions:             delete:                 type: delete                 entity_name: %orocrm_contact.entity.class%                 data_identifier: c.id                 acl_resource: orocrm_contact_delete                 label: oro.grid.action.delete                 icon: trash         options:             entityHint: contact             export: true

error is:

request.CRITICAL: Uncaught PHP Exception Twig_Error_Runtime: "An exception has been thrown during the rendering of a template ("[Syntax Error] line 0, col 64: Error: Expected IdentificationVariable | ScalarExpression | AggregateExpression | FunctionDeclaration | PartialObjectExpression | "(" Subselect ")" | CaseExpression, got '?'") in "/fakepath/vendor/oro/platform/src/Oro/Bundle/UIBundle/Resources/views/actions/index.html.twig" at line 206." at /fakepath/vendor/twig/twig/lib/Twig/Template.php line 148 []

1 2 3

request.CRITICAL: Uncaught PHP Exception Twig_Error_Runtime: "An exception has been thrown during the rendering of a template ("[Syntax Error] line 0, col 64: Error: Expected IdentificationVariable | ScalarExpression | AggregateExpression | FunctionDeclaration | PartialObjectExpression | "(" Subselect ")" | CaseExpression, got '?'") in "/fakepath/vendor/oro/platform/src/Oro/Bundle/UIBundle/Resources/views/actions/index.html.twig" at line 206." at /fakepath/vendor/twig/twig/lib/Twig/Template.php line 148  []

Topic

[IvanParticipant]

oro/platform 1.4.4
oro/crm 1.4.2

[Author]

Replies