3 Replies Latest reply on Mar 4, 2016 5:30 AM by Horia Chiorean

    Full-text searching on multi-valued properties

    Rustam Usmanov Apprentice

      Having repository with no index providers explicitly configured I'm trying to search for nt:unstructured nodes with different properties using full-text searching facilities. Using full-text search language of ModeShape gives me too broad results when I need to search on specific property only.

       

      So, considering that FT language statement

      "foo"

      have a JCR-SQL2 equivalent of

      "SELECT * FROM [nt:unstructured] AS r WHERE CONTAINS(r.*, 'foo')"

      , I'm trying to use more specific query, including property name into it:

      "SELECT * FROM [nt:unstructured] AS r WHERE CONTAINS(r.[ns:bar], 'foo')".


      The problem is that it gives expected results for single-valued properties only, not for multi-valued ones.

      At same time mode broad query "SELECT * FROM [nt:unstructured] AS r WHERE CONTAINS(r.*, 'foo')"

      gives expected results for all properties, including multi-valued.


      Did I miss something?