[Vtigercrm-developers] You can not create chart reports on Events grouped by Status

Sukhdev Mohan s.mohan at myti.it
Tue Jun 22 12:00:47 GMT 2021


The entire Calendar module is flooded with this kind of issues...

You can try to create a dashboard widget by doing the query and displaying
it in a day board widget... This wouldn't dice the problem but you'd have a
report-ish

Il mar 22 giu 2021, 13:56 nilay khatri <nilay.spartan at gmail.com> ha scritto:

> Hi All,
>
> We have a simple chart to make, a bar chart which shows record counts
> grouped by Event's Status.
>
> When we go to create  a chart report firstly, we can select only one
> module Calendar, there is no separate Events and Tasks.
>
> Secondly, under Group By field selection we get only one Status field!
> Whereas in conditions, we get Status field 2 times with same name "Calendar
> Status".
>
> So if we set the group field by status and save the report, it will show
> results only based on Tasks. We can not get a report which is for Events.
>
> Doing some debugging found out that it is because the field list is
> generated based on Field labels! I don't know why in the world.
>
> So to try a quick hack, we changed the fieldlabels in the database to Task
> Status and Events Status respectively. This fixes the issues partly. Now we
> get 2 fields to select from, but even then the data is not generated.
>
> But this introduces another issue in Calendar List view, where now both
> the Event Status and Task status columns would show same values.
>
>
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210622/381f1497/attachment.html>


More information about the vtigercrm-developers mailing list