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!

View Revisions: Issue #108		[ All Revisions ] [ Back to Issue ]
Summary	0000108: Add "multiple" option to possible field options, when kOptionsFormatter is used (helps in search queries)

Revision	2009-07-08 04:57:53 by alex
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\|%'

Revision	2009-07-08 04:57:06 by alex
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\|%'

Revision	2009-07-08 04:56:43 by alex
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` <code>IN (ID1, ID2) Search query without "multiple" parameter: `FieldName` LIKE '%\|ID1\|%' OR `FieldName` LIKE '%\|ID2\|%'

Web Development by Intechnic

In-Portal Open Source CMS