Uploaded image for project: 'Magnolia UI'
  1. Magnolia UI
  2. MGNLUI-6016

Column filtering with comboBoxField and optionListDatasource creates wrong query

    XMLWordPrintable

Details

    • Bug
    • Resolution: Duplicate
    • Neutral
    • None
    • None
    • None
    • None

    Description

      I don´t get any results if i configure my column filter like this: https://git.magnolia-cms.com/projects/INCUBATOR/repos/uri-mapping-app/browse/src/main/resources/uri-mapping-app/apps/uri-mapping-app.yaml?at=refs%2Fheads%2FupdateTo6.2

      Speaking about this part:

      - name: actionPrefix
        label: Action Prefix
        width: 100
        filterComponent:
          $type: comboBoxField
          emptySelectionAllowed: true
          textInputAllowed: true
          filteringMode: STARTSWITH
          datasource:
            $type: optionListDatasource
            options:
              forward:
                value: forward
              redirect:
                value: redirect
              permanent:
                value: permanent
      
      

      Checked the problem whit rkovarik and he told me that the Quer is created like this: 

      LOWER(t.value) like ‘%info.magnolia.ui.datasource.optionlist.option@4e382f59%’

      Checklists

        Acceptance criteria

        Attachments

          Issue Links

            Activity

              People

                Unassigned Unassigned
                tobias.kerschbaum Tobias Kerschbaum
                Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Checklists

                    Bug DoR
                    Task DoD

                    Time Tracking

                      Estimated:
                      Original Estimate - Not Specified
                      Not Specified
                      Remaining:
                      Remaining Estimate - 0d
                      0d
                      Logged:
                      Time Spent - 20m
                      20m