Reports & Account Name

💬 General Discussion
1

If you make a report with the field Opportunities/Account Name No results will show up.

2

Thank you for highlighting this.

I have tested/confirmed and logged a bug on the SuiteCRM GitHub Repository.

Thanks,

Will.

3

Just ran into this.

AOR_Report.php:684

$query = $this->build_report_query_join($data['relationship'],$table_alias, $oldAlias, $field_module, 'relationship', $query, $new_field_module);

$oldAlias is not set to anything. Which produces:

LEFT JOIN accounts_opportunities [|accounts] ON [].id=[|accounts].opportunity_id AND [|accounts].deleted=0

Needs

$oldAlias = $table_alias;

before 682.

Haven’t investigated but, after this fix, using this field as a parameter is also not working.