I want to show the context record for a Calendar Event in the Datagrid.
Is it possible? I can see that the information is stored in relation tables named as ‘oro_rel_dj73yejkd98’ or something like that. How can I make a join to this table? Is there any entity / class that is associated with this table? Because in the Datagrid only ORM datasource is implemented so I cannot give a table name directly in the joins.
So how can I show the context information in a datagrid? This is for one of my reports.
Please let me know urgently as the customer is waiting for this report.
I basically want to show the following fields in one report:
Business Unit, Username, Account Name (context), Calendar Event Title, Time of meeting, (and some custom fields)
The custom fields capture the information whether they have attended the meeting or not.
The other way I can think of is directly make calls to the database in the controller by running SQL queries and sending the resultset array to a twig file and show the information in a table. But I would not be able to show filters and coding all those things will take lot of time. And also I would lose the responsive feature.
Please advise how can I go ahead with this requirement. Please help.
Thanks and Regards,
You must be logged in to reply to this topic.