Does asset share commons search allows searching for text with in a document (PDF/Word/PPT) ? | Community
Skip to main content
D
Adobe Employee
digarg17Adobe Employee
Adobe Employee
September 16, 2024
Solved

Does asset share commons search allows searching for text with in a document (PDF/Word/PPT) ?

  • September 16, 2024
  • 5 replies
  • 1414 views

I searched for the term "contrary" in reference implementation in the search bar and only got a PDF. I was expecting both PDF and Word doc to show as search results as both had the same text and content. I am not sure if ASC supports search based on text/contents within the document. Can someone confirm if full-text content search within docs is supported in ASC?

https://aem.enablementadobe.com/content/asset-share-commons/en/light.html?fulltext=contrary&1_group.propertyvalues.property=.%2Fjcr%3Acontent%2Fmetadata%2Fdc%3Aformat&1_group.propertyvalues.operation=equals&1_group.propertyvalues.1_values=application%2Fvnd.openxmlformats-officedocument.wordprocessingml.document%2Capplication%2Fpdf%2Ctext%2Fplain&orderby=%40jcr%3Acontent%2Fjcr%3AlastModified&orderby.sort=desc&layout=card&p.offset=0&p.limit=1

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by TarunKumar

HI @digarg17 ,

If the query is working for you on author and not on publisher instance then there might be some issue with indexing.
You can try to follow below steps:

1. Go to query performance console in your author <host>:<port>libs/granite/operations/content/diagnosistools/queryPerformance.html and inside explain query tab you can test the query, look if it finds any indexing.

 

2. Try to follow the step 1 in your publish instance and compare the result of author.

3. Also run your query in query debugger tool of publisher and check for results

4. Go to the indexed used in both author and publisher and compare the nodes property.

5. If you don't see any differences then manually trigger the indexing in publish.

 

-Tarun

 

 

5 replies

kautuk_sahni
Community Manager
kautuk_sahniCommunity Manager
Community Manager
September 17, 2024

@h_kataria @tarunkumar @mukeshyadav_ Could you kindly take a look at this question and provide your thoughts? Your insights would be greatly appreciated.

Kautuk Sahni
diksha_mishra
Community Advisor
diksha_mishraCommunity Advisor
Community Advisor
September 17, 2024

@digarg17  By default, fulltext search is enabled for PDFs in DAM. You need to customize this search behavior for word documents, as below:

1. Ensure Full-Text Indexing for DOCX Files

AEM’s Oak indexing system, using Apache Tika, can extract the text content from Word documents. You need to ensure that this is correctly configured.

  • Check Tika for DOCX Support: AEM uses Tika to extract text from DOCX files. To verify that Tika is correctly configured:
    1. Go to CRX/DE Lite (/crx/de).
    2. Navigate to the DAM Lucene Index: /oak:index/damAssetLucene (or your custom asset index if you have one).
    3. Ensure that the index rules for the DAM assets include DOCX file types. You can inspect if the file type application/vnd.openxmlformats-officedocument.wordprocessingml.document is being indexed.

Ensure the indexing rule includes the content of the Word documents by ensuring properties like jcr:content/metadata are indexed.

2. Configure Asset Share Commons for DOCX Full-Text Search

Once DOCX files are being indexed, configure Asset Share Commons to allow searching within DOCX content.

  1. Modify Search Facets in Asset Share Commons:

    • Add a Full-Text Predicate to the search query, which searches through the text content extracted from the DOCX file.
    • You can include the fulltext property in your search predicates as shown in the following configuration:

    Example full-text predicate configuration:

    json
     
    { "predicates": [ { "type": "fulltext", "path": "/content/dam", "relPath": "jcr:content/metadata", // Where the DOCX text content is extracted. "property": "fulltext", "operation": "CONTAINS" } ] }

  2. Update Oak Index for DOCX Files: If you’re using a custom Oak index (e.g., damAssetLucene), ensure that the index is configured to include DOCX files. You can modify the indexing rules to ensure it includes full-text fields for DOCX files.

    In CRX/DE:

    • Navigate to /oak:index/damAssetLucene.
    • Ensure that the indexRules/dam:Asset/properties include the relevant fields for DOCX files, like jcr:content/metadata.
    • This will allow the text from DOCX files to be searchable.

  3. Modify Search Bar to Use Full-Text Predicate: Ensure that the search bar or component on your Asset Share Commons page is configured to use the fulltext predicate. This will allow users to enter search terms that will match content inside DOCX files.

3. Example Full-Text Search Query for DOCX in AEM

A JCR SQL2 query that searches for text within DOCX documents might look like this:

sql
SELECT * FROM [dam:Asset] AS asset WHERE CONTAINS(asset.[jcr:content/metadata], 'searchTerm') AND ISDESCENDANTNODE(asset, '/content/dam') AND asset.[jcr:content/metadata/dc:format] = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'

This query searches for the searchTerm within the metadata of DOCX files (dc:format for DOCX is specified as 'application/vnd.openxmlformats-officedocument.wordprocessingml.document') in the /content/dam folder.

4. Testing the Implementation

Once the full-text indexing and Asset Share Commons configuration is in place:

  • Upload a Word document (DOCX) into AEM DAM.
  • Wait for AEM to index the document and extract the text content using Tika.
  • Test the search functionality in Asset Share Commons by entering a term that exists within the DOCX document to see if it returns the appropriate results.

Please let me know how it goes.

 

    D
    Adobe Employee
    digarg17Adobe EmployeeAuthor
    Adobe Employee
    September 18, 2024

    On author it gives both results (doc and pdf) without doing any changes On new cloud prod instance. Issue is only on publisher with ASC.

     

      TarunKumar
      Community Advisor
      TarunKumarCommunity AdvisorAccepted solution
      Community Advisor
      September 19, 2024

      HI @digarg17 ,

      If the query is working for you on author and not on publisher instance then there might be some issue with indexing.
      You can try to follow below steps:

      1. Go to query performance console in your author <host>:<port>libs/granite/operations/content/diagnosistools/queryPerformance.html and inside explain query tab you can test the query, look if it finds any indexing.

       

      2. Try to follow the step 1 in your publish instance and compare the result of author.

      3. Also run your query in query debugger tool of publisher and check for results

      4. Go to the indexed used in both author and publisher and compare the nodes property.

      5. If you don't see any differences then manually trigger the indexing in publish.

       

      -Tarun

       

       

        kautuk_sahni
        Community Manager
        kautuk_sahniCommunity Manager
        Community Manager
        September 25, 2024

        @digarg17 Did you find the suggestions helpful? Please let us know if you require more information. Otherwise, please mark the answer as correct for posterity. If you've discovered a solution yourself, we would appreciate it if you could share it with the community. Thank you!

        Kautuk Sahni
        abhishekanand_
        Community Advisor
        abhishekanand_Community Advisor
        Community Advisor
        September 25, 2024

        Hi @digarg17 


        Short Answer yes it is supported in ASC i did a POC for a client some months back.

        but you need to search the a complete text which is being mentioned in file for instance lets say "Abhishek" is there in the file it won't result until i search "Abhishek" not a single character should be missing or misplaced.

        Abhishek Anand
          Terms & ConditionsAccessibility statement

          Loading footer...