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

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Neutral
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Sprint:
      Basel 136, Basel 137, Basel 138, Basel 139

      Description

      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.

        Attachments

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

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Date of First Response: