|
Viewing Issue Simple Details |
|
ID |
Category |
Type |
Reproducibility |
Date Submitted |
Last Update |
|
0000083 |
[In-Portal CMS] Admin Interfaces |
feature request |
N/A |
2009-06-16 12:36 |
2009-10-03 07:56 |
|
|
Reporter |
alex |
View Status |
public |
|
|
Assigned To |
alex |
|
Priority |
normal |
Resolution |
fixed |
|
|
Status |
closed |
|
|
|
|
|
Summary |
0000083: Ability to enter sql queries and phrases as custom field options |
|
Description |
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. |
|
Additional Information |
|
related to 
child of 
duplicate of