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

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?