Advanced search error

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.

What version of Suite are you using?

This is known issue in 7.7.7 and 7.6.9, if you are using either of these version I would suggest you upgrade to resolve the issue

1 Like

Yes this was the issue, i was running 7.7.7. Did not realize there was a new release. Thank you !!!