In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
83 [In-Portal CMS] Admin Interfaces feature request N/A 2009-06-16 12:36 2009-10-03 07:56
none 5.0.0  
0000083: Ability to enter sql queries and phrases as custom field options
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.
Issue History
2009-10-03 07:56 administrator Note Added: 0000675
2009-10-03 07:56 administrator Status resolved => closed
2009-06-16 13:08 alex Target Version => 5.0.0
2009-06-16 13:08 alex Fixed in Version => 5.0.0
2009-06-16 12:59 alex Note Added: 0000071
2009-06-16 12:59 alex Status active => resolved
2009-06-16 12:59 alex Resolution open => fixed
2009-06-16 12:59 alex Assigned To => alex
2009-06-16 12:59 alex Changeset attached RC r11854
2009-06-16 12:36 alex New Issue

2009-06-16 12:59   
Fix committed to RC branch. 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.
2009-10-03 07:56   
Closing issues from 5.0.0 version, because version was already released.