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!

Viewing Issue Advanced Details Jump to Notes ] Wiki ] View Simple ] Issue History ] Print ]
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 Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Platform
Status closed   OS
  OS Version
ETA none Fixed in Version 5.0.0 Product Version
  Target Version 5.0.0 Product Build
Time EstimateNo estimate
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.
Steps To Reproduce
Additional Information
Tags No tags attached.
Reference
Change Log Message
Estimate Points 0
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
User avatar (0000071)
alex (manager)
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.
User avatar (0000675)
administrator (administrator)
2009-10-03 07:56

Closing issues from 5.0.0 version, because version was already released.

- Related Changesets
In-Portal CMS: RC r11854
Timestamp: 2009-06-16 12:59:24
Author: alex
Details ] Diff ]
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.
mod - /in-portal/branches/RC/core/admin_templates/custom_fields/custom_fields_edit.tpl Diff ] File ]
mod - /in-portal/branches/RC/core/admin_templates/js/form_controls.js Diff ] File ]
mod - /in-portal/branches/RC/core/units/custom_fields/custom_fields_event_handler.php Diff ] File ]
mod - /in-portal/branches/RC/core/units/general/custom_fields.php Diff ] File ]
mod - /in-portal/branches/RC/core/units/general/helpers/mod_rewrite_helper.php Diff ] File ]

- Issue History
Date Modified Username Field Change
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



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

Powered by Mantis Bugtracker