Populate Enum Field from Database using SQL statements specified in metadata.

[telecastg]

This is a new field free plug-in that allows a developer to specify SQL statements in the field definition metadata to populate a select list with the results of the query.

Feel free to check it out, read the code to get a good grasp of how is this accomplished, test it and please report any bugs. It's working fine for us making a select element (enum) change based on the values of the results of a query but it hasn't been thoroughly tested.

https://github.com/telecastg/Enum-from-SQL-Field-for-EspoCRM

[telecastg]

Kyle has reported a security risk using this extension because at present a user might inject sql by copying and modifying the ajax payload.

I will look into this, but in the mean time please take the necessary precautions if you are using or plan to use this extension.

This free extension and others that I have published are NOT commercial products so they have not been tested thoroughly, they are experimental code examples meant to illustrate ways in which Espo can be customized.