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 Simple Details [ Jump to Notes ] [ Wiki ]

[ View Advanced ] [ Issue History ] [ Print ]

Category

Type

Reproducibility

Date Submitted

Last Update

0000108

[In-Portal CMS] Front End

feature request

N/A

2009-07-08 04:56

2009-10-03 07:56

Reporter

alex

View Status

public

Project Name

In-Portal CMS

Assigned To

alex

Developer

Priority

normal

Resolution

fixed

Fixed in Version

5.0.0

Status

closed

Product Version

Target Version

5.0.0

Time Estimate

No estimate

Summary

0000108: Add "multiple" option to possible field options, when kOptionsFormatter is used (helps in search queries)

Description

I propose to add "multiple" field option to fields, that are using kOptionsFormatter class (in "formatter" option). Value in such fields is selected from limited value list, that is also set in field options (in "options" option). There is possible case, when user can select multiple values into same field (<select multiple></select>). When building search query we have no idea about value format, that is stored in field. For single value fields that value is stored as is, but for multiple value fields selected values are stored in "|ID1|ID2|ID3|" format.

Search query without "multiple" parameter:
`FieldName` IN (ID1, ID2)

Search query without "multiple" parameter:
`FieldName` LIKE '%|ID1|%' OR `FieldName` LIKE '%|ID2|%'

Additional Information

Tags

No tags attached.

Reference

http://wiki.intechnic.lv/index.php/%D0%97%D0%B0%D1%8F%D0%B2%D0%BA%D0%B0:%D0%9F%D0%B0%D1%80%D0%B0%D0%BC%D0%B5%D1%82%D1%80_multiple_%D0%B4%D0%BB%D1%8F_%D0%BA%D0%BB%D0%B0%D1%81%D1%81%D0%B0_kOptionsFormatter

Change Log Message

Estimate Points

Attached Files

Relationships [ Relation Graph ] [ Dependency Graph ]

related to

0000078

closed (5.0.0)

alex

Make Custom Fields Searchable

Notes
(0000121) alex (manager) 2009-07-08 05:14	Fix committed to RC branch. Commit Message: Fixes 0000108: Add "multiple" option to possible field options, when kOptionsFormatter is used (helps in search queries)

(0000665) 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 r11895 Timestamp: 2009-07-08 05:14:03 Author: alex [ Details ] [ Diff ]	Fixes 0000108: Add "multiple" option to possible field options, when kOptionsFormatter is used (helps in search queries)
	mod - /in-portal/branches/RC/core/kernel/kbase.php	[ Diff ] [ File ]
	mod - /in-portal/branches/RC/core/units/custom_data/custom_data_event_handler.php	[ Diff ] [ File ]
	mod - /in-portal/branches/RC/core/units/general/helpers/search_helper.php	[ Diff ] [ File ]

Issue History
Date Modified	Username	Field	Change
2009-10-03 07:56	administrator	Note Added: 0000665
2009-10-03 07:56	administrator	Status	resolved => closed
2009-07-08 05:14	alex	Fixed in Version	=> 5.0.0
2009-07-08 05:14	alex	Target Version	=> 5.0.0
2009-07-08 05:14	alex	Note Added: 0000121
2009-07-08 05:14	alex	Status	active => resolved
2009-07-08 05:14	alex	Resolution	open => fixed
2009-07-08 05:14	alex	Assigned To	=> alex
2009-07-08 05:14	alex	Changeset attached	RC r11895
2009-07-08 05:02	alex	Relationship added	related to 0000078
2009-07-08 04:57	alex	Description Updated	View Revisions
2009-07-08 04:57	alex	Description Updated	View Revisions
2009-07-08 04:56	alex	New Issue
2009-07-08 04:56	alex	Reference	=> http://wiki.intechnic.lv/index.php/%D0%97%D0%B0%D1%8F%D0%B2%D0%BA%D0%B0:%D0%9F%D0%B0%D1%80%D0%B0%D0%BC%D0%B5%D1%82%D1%80_multiple_%D0%B4%D0%BB%D1%8F_%D0%BA%D0%BB%D0%B0%D1%81%D1%81%D0%B0_kOptionsFormatter

Web Development by Intechnic

In-Portal Open Source CMS