Uploaded image for project: 'OASIS Open Data Protocol (OData) TC'
  1. OASIS Open Data Protocol (OData) TC
  2. ODATA-1594

Add support for fuzzy search function within $filter, etc.

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: V4.01_OS
    • Fix Version/s: V4.02
    • Component/s: Protocol, URL Conventions
    • Labels:
      None
    • Proposal:
      Hide

      Introduce a new string function, "search", which does a content search on the first parameter for the search text provided by the second parameter.  The second parameter can support the same syntax as the $search query option.

       

      Alternative names: "fuzzyMatch", "fuzzySearch", "contentMatch", "contentSearch"

       

      Show
      Introduce a new string function, "search", which does a content search on the first parameter for the search text provided by the second parameter.  The second parameter can support the same syntax as the $search query option.   Alternative names: "fuzzyMatch", "fuzzySearch", "contentMatch", "contentSearch"  

      Description

      The $search functionality allows fuzzy searching across all properties, and is useful for finding entities that have something to do with a particular search term.

      However, some engines may support content search on a particular field, and customers may want to combine such content searches with other predicates, for example:

      /users?$filter=address/state eq 'WA' or search(jobTitle,'smith')

      Note:

      1) They specifically want job titles related to a "smith" (woodsmith, ironsmith, etc.), not last names related to "smith"
      2) They want to logically "OR" this condition with other conditions within the $filter clause.

      They can't do either #1 or #2 with $search today.

        Attachments

          Activity

            People

            • Assignee:
              mikep Michael Pizzo
              Reporter:
              mikep Michael Pizzo
            • Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: