Ability to enter sql queries and phrases as custom field options
Components
Labels
Description
Context Information
Additional information (do not use)
Activity
Former user October 3, 2009 at 12:56 PM
Closing issues from 5.0.0 version, because version was already released.
Alex June 16, 2009 at 5:59 PM
Fix committed to [b]RC branch/b. Commit Message:
1. Fixes #0000083: Ability to enter sql queries and phrases as custom field options.
2. htmlspecialchars function (in javascript) wasn't applied on options added in MInput control (inp_edit_minput block).
3. Commented-out code removed from kModRewriteHelper class, because was proven, that code if uncommented doesn't provide any upgrade to current url parsing functionality. In other words - all works without it in all cases.
Details
Details
Priority
MinorAssignee
Reporter
Patch Instructions
Patches must be submitted through Phabricator.
To submit patch via Command Line use Patches Workflow (via Arcanist) tutorial.
To submit patch via Web Interface use Patches Workflow (via Web Interface) tutorial.
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.