Uploaded image for project: 'ModeShape'
  1. ModeShape
  2. MODE-2451

Automatically consider nt:resource children if full-text searching on an nt:file

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Won't Do
    • Major
    • None
    • None
    • None
    • None

    Description

      This one's a bit of a stretch, so feel free to reject if you disagree.

      See https://developer.jboss.org/message/922586 for background. I was having trouble getting full-text searching to use the Tika extractors on file content. I needed the search to consider both metadata values on the nt:file, in addition to file content on the nt:resource child. The query can contain other constraints specific to the sramp:baseArtifactType mixin, so simply querying nt:base or nt:resource isn't possible.

      I mistakenly had:
      SELECT artifact1.* FROM [sramp:baseArtifactType] AS artifact1 WHERE CONTAINS(artifact1, 'foobar')

      but needed:
      SELECT artifact1.* FROM [sramp:baseArtifactType] AS artifact1 LEFT OUTER JOIN [nt:resource] AS content1 ON ISCHILDNODE(content1,artifact1) WHERE CONTAINS(artifact1,'foobar') OR CONTAINS(content1,'foobar')

      As common as that situation may be, is it at all possible to support automatically handling the nt:resource child if the former query is used (assuming '.*' or no property names are used)? Or add some sort of new method to QOMF that would do it?

      Attachments

        Activity

          People

            Unassigned Unassigned
            brmeyer_jira Brett Meyer (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: