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

In-Portal Issue Tracker - In-Portal CMS

Viewing Issue Advanced Details

ID:

Category:

Type:

Reproducibility:

Date Submitted:

Last Update:

108

[In-Portal CMS] Front End

feature request

N/A

2009-07-08 04:56

2009-10-03 07:56

Reporter:

alex

Platform:

Assigned To:

alex

OS:

Priority:

normal

OS Version:

Status:

closed

Product Version:

Product Build:

Resolution:

fixed

ETA:

none

Fixed in Version:

5.0.0

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:

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|%'

Steps To Reproduce:

Additional Information:

Relationships

related to

0000078

closed (5.0.0)

alex

Make Custom Fields Searchable

Attached Files:

Issue History

Date Modified

Username