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

Column filtering with comboBoxField and optionListDatasource creates wrong query

XMLWordPrintable

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

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

        Acceptance criteria

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

                Created:
                Updated:
                Resolved:

                  Bug DoR
                  Task DoD

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