Search Leads Advanced I no longer can search using Lead Source I get "No results found"


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

best regards

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_cstm.sales_account_c,accounts_cstm.syspro_industry_c, accounts.parent_id , accounts.assigned_user_id , , 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 ASC) AS row_number
FROM accounts LEFT JOIN accounts_cstm ON = accounts_cstm.id_c LEFT JOIN accounts jt0 ON AND jt0.deleted=0

AND jt0.deleted=0 LEFT JOIN users jt1 ON 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.

1 Like


Yes that did seem to fix it



1 Like

The below fixed worked!!! Thanks!

1 Like