on the Search Leads screen using Advanced Search I’m no longer able to find any records when choosing any of the selections in Lead Source box. I get “No results found”. I’ve tried all of them and I get nothing. This was working and I’m not sure why it is now broken.
I’m also having the same issue with Status box. All of the selections return “No results found”
Any help would be greatly appreciated.
you need to provide your SuiteCRM version, so we can test it out
Sorry, here is the version and build. Version 7.7.7 Sugar Version 6.5.24 (Build 509). Thanks!
Hi I have just built a SuiteCRM instance from a SugarCRM build everything worked properly from the upgrades but when searching with anything other than an empty selection I get no data returned. (sugarcrm 6.5.18 to SuiteCRM 7.7.7
See the Query being run below, the 's around the values in the sql statement are missing.
SELECT accounts.id ,accounts_cstm.sales_account_c,accounts_cstm.syspro_industry_c, accounts.parent_id , accounts.assigned_user_id , accounts.name , jt0.name parent_name , jt0.assigned_user_id parent_name_owner , N’Accounts’ parent_name_mod, accounts.account_type , accounts.billing_address_city , jt1.user_name assigned_user_name , jt1.created_by assigned_user_name_owner , N’Users’ assigned_user_name_mod, accounts.date_entered , accounts.created_by , ROW_NUMBER()
OVER (ORDER BY accounts.name ASC) AS row_number
FROM accounts LEFT JOIN accounts_cstm ON accounts.id = accounts_cstm.id_c LEFT JOIN accounts jt0 ON accounts.parent_id=jt0.id AND jt0.deleted=0
AND jt0.deleted=0 LEFT JOIN users jt1 ON accounts.assigned_user_id=jt1.id AND jt1.deleted=0
AND jt1.deleted=0 where ((accounts.account_type in (ManagedAccount))) AND accounts.deleted=0
) AS a
WHERE row_number > 0::: [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name ‘ManagedAccount’.
If this is related I would have a look at this and see if this fix works.
Yes that did seem to fix it
The below fixed worked!!! Thanks!