Bug in AOR_Report.php

SuiteCRM Forum - English Language SuiteCRM Feedback
#1

Hi,

We had issues with dropdown fields in reports (Version 7.8.1) and found that there are some parentheses missing in line 1511 of AOR_Report.php.

Before:

if (!$where_set) $query['where'][] = ($tiltLogicOp ? '' : ($condition->logic_op ? $condition->logic_op . ' ': 'AND ')) . $field . ' ' . $aor_sql_operator_list[$condition->operator] . ' ' . $value;

After:

if (!$where_set) $query['where'][] = ($tiltLogicOp ? '' : ($condition->logic_op ? $condition->logic_op . ' ': 'AND ')) . '(' . $field . ' ' . $aor_sql_operator_list[$condition->operator] . ' ' . $value . ')';

This is to make sure the ‘OR’ in line 1480 does not mess things up in the query.

Hope this will be fixed in the next release.

Thanks,

Felix

#2

Can you please post this on Github?