Uploaded image for project: '{RETIRED} XWiki Enterprise'
  1. {RETIRED} XWiki Enterprise
  2. XE-47

Search should be case insensitive

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Minor
    • 1.0 RC1
    • 1.0 B5
    • None
    • Windows XP SP2, Tomcat, XWiki 1b5, PostgreSQL
    • patch

    Description

      XWiki does case sensitive search, e.g. if I search for "available", available will be found, but not "Available." It seems that this does not happen with buil-in storage, just with database.

      Solution: change search page Main.WebSearch so it ignore case:

      from:

        1. -----------------------------------------------------------
        2. Search in page content
        3. -----------------------------------------------------------
          #set ($sql = "where $webClause doc.content like '%$!text%' order by doc.date desc")

      to:

        1. -----------------------------------------------------------
        2. Search in page content
        3. -----------------------------------------------------------
          #set ($sql = "where $webClause upper(doc.content) like upper('%$!text%') order by doc.date desc")

      Attachments

        Issue Links

          Activity

            People

              vmassol Vincent Massol
              zeljko Zeljko Trogrlic
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: