Uploaded image for project: 'Magnolia DAM Module'
  1. Magnolia DAM Module
  2. MGNLDAM-737

Fix Assets app search to handle search for doc, docx, and pdf file content

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Neutral Neutral
    • None
    • None
    • None
    • None
    • Basel 136, Basel 137, Basel 138, Basel 139

      In Assets app, users are unable to search for doc, docx, or pdf file content.

      The query created (from SearchJcrContainer) is (for example):
      select * from [nt:base] as t where (([jcr:primaryType] = 'mgnl:asset' or [jcr:primaryType] = 'mgnl:folder') and (lower(localname()) LIKE 'is a test%' or t.['is a test'] IS NOT NULL or contains(t.*, 'is a test')) )

      but in JCR the file content is stored under mgnl:resource node type (see example attached). The test document used is also attached.

      You are able to search for the file content by adding the mgnl:resource node type to the search query (example below, you can test in JCR Tools app).

      select * from [nt:base] as t where (([jcr:primaryType] = 'mgnl:asset' or [jcr:primaryType] = 'mgnl:folder' or [jcr:primaryType] = 'mgnl:resource') and (lower(localname()) LIKE 'is a test%' or t.['is a test'] IS NOT NULL or contains(t.*, 'is a test')) )

      An appropriate solution still needs to be determined and this ticket will need to be updated.

        Acceptance criteria

          1. dam.test..doc.xml
            32 kB
          2. integration-points.pdf
            37 kB
          3. test.doc
            22 kB
          4. walkthrough563.pdf
            130 kB

              Unassigned Unassigned
              lstaniorski Leah Staniorski
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Created:
                Updated:
                Resolved: