How to search duplicate node by JCR-SQL2 | Community
Skip to main content
J
jiaBai
Level 3
July 8, 2021
Solved

How to search duplicate node by JCR-SQL2

  • July 8, 2021
  • 1 reply
  • 1164 views

Hi Guys,

 

I have issue that need to retrieve duplicate node name from two node's subset via JCR-Sql2 as below attachment.

The search result should be /aa/cc and /aa/dd .

 

But I always got below ParseException, does anyone know how to correct this Sql clause and make it working correct?

Or if you know the correct JCR-Sql2 query.

Thanks in advance.

 

SELECT * FROM [nt:base] AS a inner join [nt:base] as b on a.[jcr:primaryType] = b.[jcr:primaryType] where ISDESCENDANTNODE(a, [/content/aa]) and ISDESCENDANTNODE(b, [/content/bb])
and name(a) = name(b)

 

    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 Dipti_Chauhan

    Hi @jiabai 

       In this query , Static operand is expected at right hand side(which is name(b)). I am also curios to know if we can compare these two nodes using query,

    If your usecase is to do some cleanup then I would suggest you to write groovy or small servlet and iterate the ndoe and do comparison on JCR property level.

     

    Thanks

    Dipti

    1 reply

    Dipti_Chauhan
    Community Advisor
    Dipti_ChauhanCommunity AdvisorAccepted solution
    Community Advisor
    July 8, 2021

    Hi @jiabai 

       In this query , Static operand is expected at right hand side(which is name(b)). I am also curios to know if we can compare these two nodes using query,

    If your usecase is to do some cleanup then I would suggest you to write groovy or small servlet and iterate the ndoe and do comparison on JCR property level.

     

    Thanks

    Dipti

      J
      jiaBaiAuthor
      Level 3
      July 9, 2021

      Hi @dipti_chauhan,

       

      Our use case only can search via JCR-Sql2 from CRX console, it's due to I have no permission to deploy bundle code in AEM.

      Otherwise, to fetch duplicate node by sql that is more simply.

       

      Please let me know if you know the correct Query syntax.

      Thanks very much.

      Terms & ConditionsAccessibility statement

      Loading footer...