AnsweredAssumed Answered

Adding a custom field to My Accounts dashlet yields MySQL error

Question asked by Merrick Dennis on Apr 7, 2014
Latest reply on Apr 15, 2014 by Merrick Dennis
Hello,

Sugar Pro 6.5.7

I have added a custom field (user relate field) in the accounts module to the Dashlet search via Studio (Accounts > Layout > Sugar Dashlet > Sugar Dashlet Search).

When I edit the dashlet options by clicking on the gear icon of the dashlet, the field appears but it is not populated with the list of users in the system.

If I view the log file while opening the dashlet, I can see the following MySQL error:

[FATAL]  Query Failed: SELECT id, name title FROM  WHERE deleted = 0 ORDER BY title ASC: MySQL error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE deleted = 0 ORDER BY title ASC' at line 1
This custom field works fine within the actual Accounts module itself (edit/detail views), but when adding it to the Dashlet it does not function properly.

Any help on how to get this working?

Outcomes