[MGNLDAM-737] Fix Assets app search to handle search for doc, docx, and pdf file content Created: 28/Feb/18  Updated: 26/Oct/18  Resolved: 19/Mar/18

Status: Closed
Project: Magnolia DAM Module
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Neutral
Reporter: Leah Staniorski Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Attachments: XML File dam.test..doc.xml     PDF File integration-points.pdf     Microsoft Word test.doc     PDF File walkthrough563.pdf    
Issue Links:
dependency
depends upon MAGNOLIA-7123 Full text search in documents (pdf, d... Closed
duplicate
duplicates MGNLDAM-667 Fix full text dam search (Assets app) Closed
Template:
Acceptance criteria:
Empty
Task DoD:
[ ]* Doc/release notes changes? Comment present?
[ ]* Downstream builds green?
[ ]* Solution information and context easily available?
[ ]* Tests
[ ]* FixVersion filled and not yet released
[ ]  Architecture Decision Record (ADR)
Bug DoR:
[ ]* Steps to reproduce, expected, and actual results filled
[ ]* Affected version filled
Date of First Response:
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.



 Comments   
Comment by Antti Hietala [ 05/Mar/18 ]

Proposal: extend searchJCRContainer for Assets app, then you change the node types.

Comment by Christopher Zimmermann [ 28/Mar/18 ]

Ive uploaded the attached doc in my assets app and searched on 1234, but I do not get any search results. What could be the problem?

Generated at Mon Feb 12 05:02:46 CET 2024 using Jira 9.4.2#940002-sha1:46d1a51de284217efdcb32434eab47a99af2938b.