This topic contains 1 reply, has 1 voice, and was last updated by musicthebee 8 years, 2 months ago.
- Topic
I am trying to create a datagrid to show the associated tasks with case and show them in the additional information of the case view page.
Here is the yml. When I do the following- I get error “(“Class oro_rel_f24c741bb3bd15b149273d does not exist”) “. The issue i have is that the tasks are associated with the case using activities and I need to do a join. However there is no static entity class that is associated with tasks from case. How do I get this and specify in the YML file?
Thanks for the help.
12345678910111213141516171819202122232425262728293031323334353637383940case-tasks-grid:extended_entity_name: %orocrm_task.entity.class%source:type: ormacl_resource: orocrm_task_viewquery:select:- task.id- task.subject- task.description- task.dueDate- tp.name as taskPriority- tp.label as priorityLabel- CONCAT(own.firstName, CONCAT(' ', own.lastName)) as ownerName- own.id as owner- task.createdAt- task.updatedAt- workflowStep.label as workflowStepLabel- rel.ticketentity_idfrom:- { table: %orocrm_task.entity.class%, alias: task }- { table: oro_rel_f24c741bb3bd15b149273d, alias: rel }join:left:- { join: task.taskPriority, alias: tp }- { join: task.owner, alias: own }- { join: rel.task_id }- { join: task.workflowStep, alias: workflowStep }inner:inner:-join: oro_rel_f24c741bb3bd15b149273dalias: relconditionType: WITHcondition: "task.id=rel.task_id"where:and:- (rel.caseentity_id = :caseId)bind_parameters:- caseId
The forum ‘OroPlatform – How do I? Questions’ is closed to new topics and replies.