[Vtigercrm-developers] V6 Report Issue

[Daniel Thompson]

Hi All,

I've noticed a bug in when querying a one to many relationship.

For example;

If I generate a report based on a contact record and its calendar events,
even though the query is left join on vtiger_activity where activitytype !=
'Emails' it also left joins on vtiger_seactivityrel because this is a left
join and one to many it productises the query result and reproduces a NULL
line value for the calendar event. SO i.e. I have one call and one email
linked to the client my result would be.

Firstname      Last Name          Calendar Subject
John                   doe                        Call
John                   doe                         --

It should also query the left join vtiger_seactivityrel to activity where
activitytype != 'Emails' or something to that effect cannot use inner join
as if no results turned up for the calendar the contact would not appear on
the report.

Regards,

Danny
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20140214/72f21090/attachment.html>