In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Dependency Graph View Issue ] Relation Graph ] Vertical ]
related to child of duplicate of

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

Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker