Hey team,
I am getting an error using the advanced search select box critera. Here is the log (the last part is where the error is):
Query Failed: SELECT aos_quotes.id , aos_quotes.billing_contact_id , aos_quotes.billing_account_id , aos_quotes.assigned_user_id , aos_quotes.number , aos_quotes.name , aos_quotes.stage , LTRIM(RTRIM(CONCAT(IFNULL(jt0.first_name,''),' ',IFNULL(jt0.last_name,'')))) billing_contact , jt1.name billing_account , aos_quotes.total_amount , aos_quotes.currency_id , aos_quotes.expiration , jt2.user_name assigned_user_name , jt2.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, aos_quotes.date_entered , aos_quotes.created_by FROM aos_quotes LEFT JOIN aos_quotes_cstm ON aos_quotes.id = aos_quotes_cstm.id_c LEFT JOIN contacts jt0 ON aos_quotes.billing_contact_id = jt0.id AND jt0.deleted=0 LEFT JOIN accounts jt1 ON aos_quotes.billing_account_id = jt1.id AND jt1.deleted=0 LEFT JOIN users jt2 ON aos_quotes.assigned_user_id=jt2.id AND jt2.deleted=0
AND jt2.deleted=0 where ((aos_quotes.stage in (Draft))) AND aos_quotes.deleted=0 ORDER BY aos_quotes.number ASC LIMIT 0,101: MySQL error 1054: Unknown column 'Draft' in 'where clause'For some reason it is not putting quotes around the criteria. Any insight on this? thanks.