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

[nilay khatri]

Thanks Uma!

On Mon, Jun 28, 2021 at 5:25 PM Uma S <uma.s at vtiger.com> wrote:

> Hi,
>
> I have recorded this issue in code
> <https://code.vtiger.com/vtiger/vtigercrm/issues/1613>
>
> On Thu, Jun 24, 2021 at 2:58 PM nilay khatri <nilay.spartan at gmail.com>
> wrote:
>
>> 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/
>>
>> _______________________________________________
>> 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/20210629/1e5083cc/attachment.html>