how to find the title which is repeated among two different content path using querybuilder | Community
Skip to main content
nareshkumarpart
Level 2
Jun 24, 2020 12:03 PM UTC
Solved

how to find the title which is repeated among two different content path using querybuilder

Hi,

how to find the title which is repeated among two different content path using querybuilder in aem 6.5.

i need this result as com.day.cq.search.result.SearchResult result. i am using this result object for pagination, total cound , exeution time in search results.

i have tried with below approach

- i have using the below constrainsts and getting the results then assign to one list and finding the repeated title then using result list. but while doing pagination and total count its giving worng data.

predicate:

1_group.1_path=/content/med/en/hm/pa/comm
1_group.2_path=/content/med/en/hw/pa/comm
1_group.p.or=true
p.limit=10
p.excerpt=false
orderby.sort=desc
p.offset=0,
2_property=jcr:content/policy-details/number

2_property.value=D-666
orderby=@jcr:content/policy-details/version
type=cq:Page

but i want to achieve this in query itself. 

could you please give me right direction.

Thanks in advance.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
kautuk_sahni
kautuk_sahniAccepted solution
Employee
Jun 29, 2020 9:15 AM UTC

Reply from @nareshkumarpart 

Thanks, Vaibhavi, Actually I have written the utility to remove the duplicates and setting the node property. So after that, I have matching the predicates in our application to fetch the records in a search. it gives somehow better performance, and without affecting the pagination logic.

 

@nareshkumarpart Can you please share some more details about this utility for posterity?

Kautuk Sahni
View reply

9 replies

kautuk_sahni
kautuk_sahniAccepted solution
Employee
Jun 29, 2020 9:15 AM UTC

Reply from @nareshkumarpart 

Thanks, Vaibhavi, Actually I have written the utility to remove the duplicates and setting the node property. So after that, I have matching the predicates in our application to fetch the records in a search. it gives somehow better performance, and without affecting the pagination logic.

 

@nareshkumarpart Can you please share some more details about this utility for posterity?

Translate
Kautuk Sahni
arunpatidar
arunpatidar
New Participant
Jun 25, 2020 7:21 PM UTC

Use SQL2 queries to perform complex comparison.

Translate
Arun Patidar
    nareshkumarpartAuthor
    Level 2
    Jun 25, 2020 9:58 AM UTC

    Thanks vaibhavi for your response. 

    - Actually the issue , Same title presents in two different content path. i want to make it one and show it in results.

    Is there any way to find the repeated title in two different path . Any join quires can achieve this using query builder.

    If i get the answer for this i can resolve this issue..

     

    Thanks in advance for your responses.

    Translate
      Vaibhavi_J
      Vaibhavi_J
      Level 7
      Jun 25, 2020 10:53 AM UTC

      Hi Naresh,

      I got your problem. Query will return both the result as path is different and data will not be treated as duplicate. But you have a way to filter. 

      After you get result you can filter out the duplicates by comparing duplicate titles. 

       

       

      Translate
      Vaibhavi_J
      Vaibhavi_J
      Level 7
      Jun 24, 2020 3:15 PM UTC

      Hi @nareshkumarpart 

       

      In below query offset and plimit value is statically set. So during pagination you are not receiving the proper count. 

       

      Solution:

      Please update the offset and plimit value dynamically. Example:From above query,in first iteration you have received the results from 0(offset is set to 0)to 10(plimit is set for 10 records). In second iteration you should fetch next 10 result, so your offset should be updated to 10 and plimit as 20.

      This should fix your issue. 

      Below summarizing for better understanding:

      • p.offset defines start of index means from which index you want to fetch records from query result.
      • p.limit defines how many records you want to fetch.
      • Each query result will display results from p.offset to p.offset + p.limit.

      Regards, 

      Vaibhavi

      Translate
        Terms & ConditionsAccessibility statement

        Loading footer...