This topic contains 4 replies, has 2 voices, and was last updated by Rodolfo 8 years, 1 month ago.
- Topic
Hi there, Please, I need some help to make this datagrid working. How can I associate the dynamic field “customer_ff3bb796_id” ? The idea is get every event from tracking passing the Customer ID as parameter.
This is my datagrid yml:
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263...datagrid:tracking-events-grid-to-webcustomer-page:source:type: ormacl_resource: oro_tracking_website_viewquery:select:- ote.name- ote.title- omc.id- ote.url- ote.value- otv.user_identifier- ote.logged_atfrom:- { table: %orocrm_magento.entity.customer.class%, alias: omc }join:inner:-join: Oro\Bundle\TrackingBundle\Entity\TrackingVisitalias: otvconditionType: WITHcondition: "omc.id=otv.customer_ff3bb796_id"-join: Oro\Bundle\TrackingBundle\Entity\TrackingVisitEventalias: otveconditionType: WITHcondition: "omc.id=otve.customer_bb9e15ff_id"-join: Oro\Bundle\TrackingBundle\Entity\TrackingEventalias: oteconditionType: WITHcondition: "ote.id=otve.web_event_id"where:and:- omc.id = :userIdbind_parameters:- userIdcolumns:id:label: oro.tracking.trackingevent.id.labeltitle:label: oro.tracking.trackingevent.title.labelname:label: oro.tracking.trackingevent.name.labelvalue:label: oro.tracking.trackingevent.value.labeluser_dentifier:label: oro.tracking.trackingevent.user_dentifier.labelurl:type: twiglabel: oro.tracking.trackingevent.url.labelfrontend_type: htmltemplate: OroTrackingBundle:TrackingEvent:Property/url.html.twiglogged_at:label: oro.tracking.trackingevent.logged_at.labelfrontend_type: datetimeproperties:id: ~...Error:
1234567...An exception has been thrown during the rendering of a template("[Semantical Error] line 0, col 145 near 'customer_ff3bb796_id':Error: Class Oro\Bundle\TrackingBundle\Entity\TrackingVisit has no field orassociation named customer_ff3bb796_id")...This is a example of query working fine:
1234567891011121314151617181920selectote.name,ote.title,omc.id,ote.url,ote.value,otv.user_identifier,ote.logged_atfrom orocrm_magento_customer omcinner join oro_tracking_visit otv onomc.id = otv.customer_ff3bb796_idinner join oro_tracking_visit_event otve onotve.customer_bb9e15ff_id = omc.idinner join oro_tracking_event ote onote.id = otve.web_event_idwhere omc.id = 373026;Thank you
The forum ‘OroPlatform – Programming Questions’ is closed to new topics and replies.