-
Type:
Feature Request
-
Status: Closed
-
Priority:
Minor
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 5.0.0
-
Component/s: Admin Interfaces
-
Labels:None
-
External issue URL:
-
External issue ID:83
-
Copy Issue Key:
-
Patch Instructions:
Currently custom fields of "select" and "multiselect" types have multi-input control that provides easy and quick interface for adding new options to them. But this relatively new interface (added in 4.3.9 release) doesn't allow user to enter SQL-query or phrase as one of the options.
It would be good to allow users enter sql queries for retrieving custom field options from another tables in format "=||<SQL>SELECT Field1 AS OptionValue, Field2 AS OptionName FROM <PREFIX>TableName ORDER BY Field2 ASC</SQL>". Also when "" is added before option, then it's assumed as plain text. Otherwise it's assumed as phrase and will be translated when required.