Anonymous | Login | Signup for a new account | 2024-04-23 23:36 CDT |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
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|%' |
Main | My View | View Issues | Change Log | Roadmap | Docs | Wiki | Repositories |
Web Development by Intechnic In-Portal Open Source CMS |