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

Uma S uma.s at vtiger.com
Mon Jun 28 11:53:52 GMT 2021


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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20210628/f864883e/attachment-0001.html>


More information about the vtigercrm-developers mailing list