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

Details

    • Bug
    • Resolution: Duplicate
    • Neutral
    • None
    • None
    • None
    • None
    • 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.

      Checklists

        Acceptance criteria

        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

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

                Dates

                  Created:
                  Updated:
                  Resolved:

                  Checklists

                    Bug DoR
                    Task DoD