Uploaded image for project: 'XWiki Platform'
  1. XWiki Platform
  2. XWIKI-5146

Support LiveTable text filtering on DBListclass columns

    XMLWordPrintable

Details

    • livetable filter
    • High
    • Medium

    Description

      Currently when using text mode in a livetable filter on a mono-select DBListClass field, we search in the "value" of the DBListClass field instea of the "display value". We also use an exact match instead of the partial match.

      We would need to build a join query to be able to make a partial match on the value of the field.

      Now this is not possible if we are using a "query" in the DBListClass. However this is possible if the class/id field/value field are filed in (regardeless of the query field is used of not).

      So I suggest we use these values of these fields if they are present and we build a join query and match both the exact value of the ID Field (allows to support the "list" filter mode) an a partial match on the value field.

      Attachments

        1. 2017-06-09-143721_1920x1080_scrot.png
          209 kB
          Pierre Bondoerffer
        2. liveTable-dblistFilter.png
          65 kB
          Marius Dumitru Florea

        Issue Links

          Activity

            People

              mflorea Marius Dumitru Florea
              ludovic Ludovic Dubost
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: