Uploaded image for project: 'In-Portal CMS'
  1. In-Portal CMS
  2. INP-89

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

    XMLWordPrintable

    Details

    • Type: Feature Request
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.0.0
    • Component/s: Front End
    • Labels:
      None

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

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                alex Alex
                Reporter:
                alex Alex
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: