SuiteCRM version 7.7.7
When performing a search by stage of sale, the log shows the following query with error
Query Failed: SELECT opportunities.id , opportunities.assigned_user_id , opportunities.name , accounts.name account_name, jtl0.account_id account_id , jt1.name accounts_opportunities_1_name, jtl1.accounts_opportunities_1accounts_ida accounts_opportunities_1accounts_ida, opportunities.sales_stage , opportunities.amount_usdollar , opportunities.currency_id , opportunities.date_closed , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , ‘Users’ assigned_user_name_mod, opportunities.date_entered , opportunities.created_by FROM opportunities LEFT JOIN opportunities_cstm ON opportunities.id = opportunities_cstm.id_c LEFT JOIN accounts_opportunities jtl0 ON opportunities.id=jtl0.opportunity_id AND jtl0.deleted=0
LEFT JOIN accounts accounts ON accounts.id=jtl0.account_id AND accounts.deleted=0
AND accounts.deleted=0 LEFT JOIN accounts_opportunities_1_c jtl1 ON opportunities.id=jtl1.accounts_opportunities_1opportunities_idb AND jtl1.deleted=0
LEFT JOIN accounts jt1 ON jt1.id=jtl1.accounts_opportunities_1accounts_ida AND jt1.deleted=0
AND jt1.deleted=0 LEFT JOIN users jt2 ON opportunities.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where ((opportunities.sales_stage in (Closed Won))) AND opportunities.deleted=0 ORDER BY opportunities.name LIMIT 0,21: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘Won))) AND opportunities.deleted=0 ORDER BY opportunities.name LIMIT 0,21’ at line 9
Is not delimiting with quotes to the stage of sale
where ((opportunities.sales_stage in (‘Closed Won’)))
any solution?