Hi,
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.
Deno
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.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.
Hi
Yes that did seem to fix it
Thanks
Paul
The below fixed worked!!! Thanks!