In AEM fulltext query find number of occurrences along with total number of matches | Community
Skip to main content
T
Adobe Employee
tasunil1Adobe Employee
Adobe Employee
November 2, 2022

In AEM fulltext query find number of occurrences along with total number of matches

  • November 2, 2022
  • 3 replies
  • 1987 views

Hi,

 

I have a working fulltext search query which finds a text in a folder

map.put("path", path);
map. Put("fulltext", matchString);
map.put("p.limit", "-1");
map.put("p.excerpt", "true");
map.put("p.offset", offset);
map.put("type", "dam:Asset");
map.put("group.p.or", "true"); 

But this returns the number of total files matching the query, I need the total number of occurrences also. Is there a way I can get that ?
This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

3 replies

krati_garg
Adobe Employee
krati_gargAdobe Employee
Adobe Employee
November 3, 2022

@tasunil1 

Have you tried executing the same query over querydebugger?
http://localhost:4502/libs/cq/search/content/querydebug.html


    T
    Adobe Employee
    tasunil1Adobe EmployeeAuthor
    Adobe Employee
    November 3, 2022

    Hello @krati_garg 

    yes I have executed it on the query debugger. It gives the total matches which the file count. But I also need the number of occurrences

      krati_garg
      Adobe Employee
      krati_gargAdobe Employee
      Adobe Employee
      November 3, 2022

      Hi @krati_garg 

      so is the total number of files found 4,

      or is the number of occurrence in the first file 1 and one in the name ?


      Didn't get the question above, however you are searching into dam, where full text search has its own limitation.
      If the selected String is stored in any jcr property, then also matching Asset would come in result set. OOTB Full text Search would not search in Asset Binary like PDF's text, unless these files are indexed into a Solr set up.

      It would be helpful to know, what we are trying to figure out by obtaining number of occurrences.

        aanchal-sikka
        Community Advisor
        aanchal-sikkaCommunity Advisor
        Community Advisor
        September 8, 2023

        Hello @tasunil1 

         

        We can only find total matches (resources) via query. Not the total occurrences.

         

        If you need this info on per asset level, then:

        • Get all matching assets (Dam:Asset)
        • For each asset, execute the same query using type=nt:base. This will give us all the sub-nodes where the string matches.
          • Every node extends from nt:base, hence every node will be evaluated by this query.

         

         

         

         

        Aanchal Sikka
          kautuk_sahni
          Community Manager
          kautuk_sahniCommunity Manager
          Community Manager
          September 12, 2023

          @tasunil1 Do you find the suggestions from users useful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. 

          Kautuk Sahni
          Terms & ConditionsAccessibility statement

          Loading footer...