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

[nilay khatri]

To me this seems to be a mishap in the Reports module rather than calendar.

There are so many places where conditions are put to check if module is
Events, consider it as Calendar.
But, actually Events and Calendar are 2 separate Entity modules! So why not
have 2 separate modules to select from in the first step of Report.

The right approach here would be to :

1. List Tasks and Events as 2 separate modules in module selection.
2. Change the Group by field selection dropdown to be based on Field names,
rather than Field labels.


Similar challenge is for Filters. The Status field comes 2 times :)



On Wed, Jun 23, 2021 at 11:19 AM Uma S <uma.s at vtiger.com> wrote:

> Hi Nilay,
>
> Please report this issue in code,vtiger.com, Let's review this further in
> a pipeline.
>
> On Tue, Jun 22, 2021 at 6:46 PM Alan Lord <alanslists at gmail.com> wrote:
>
>> Ahh - the joys of the Calendar module...
>>
>> lol
>>
>> On 22/06/2021 12:49, nilay khatri wrote:
>> > 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/
>> >
>> _______________________________________________
>> http://www.vtiger.com/
>
>
>
> --
> With
> Best Regards
> Uma.S
> Vtiger Team
> _______________________________________________
> http://www.vtiger.com/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210624/01d2520d/attachment.html>