Filter issues with custom fields

[Mac-Rae]

Unable to filter with custom fields

Hello forum, Started a topic some days ago but had no answer, giving it a second chance just in case it got lost in the stream of topics. So i recently started using SuiteCRM, i am in version 7.12.3, and when using filters i get “MySQL error 1054: Unknown column ‘accounts.bonus_phone_1_c’ in ‘where clause’”. Obviously the bonus_phone_1_c is a custom field in accounts module, so it is stored in accounts_cstm table and not accounts, tried some solutions i found online but nothing worked. Anyone …

Post Locked!