Cannot sorting result for multiple path in AEM 6.3 | Community
Skip to main content
R
rayow4694015
June 26, 2019
Solved

Cannot sorting result for multiple path in AEM 6.3

  • June 26, 2019
  • 5 replies
  • 3218 views

Dear All

i need your help to solve my issue below. i have a query

type=cq:Page

group.1_path=/content/we-retail/us/en/experience

group.2_path=/content/we-retail/us/en/men

group.3_path=/content/we-retail/us/en/women

group.4_path=/content/we-retail/us/en/equipment

group.p.or=true

orderby=@jcr:created

p.limit=-1

when i click execute the error

java.text.ParseException: (/jcr:root/content/we-retail/us/en/experience//element(*, cq:Page) | /jcr:root/content/we-retail/us/en/men//element(*, cq:Page) | /jcr:root/content/we-retail/us/en/women//element(*, cq:Page))order by @jcr:created converted to SQL-2 Query: select [jcr:path], [jcr:score], * from [cq:Page] as a where isdescendantnode(a, '/content/we-retail/us/en/experience') /* xpath: /jcr:root/content/we-retail/us/en/experience//element(*, cq:Page) order by @jcr:created */ union select [jcr:path], [jcr:score], * from [cq:Page] as a where isdescendantnode(a, '/content/we-retail/us/en/men') /* xpath: /jcr:root/content/we-retail/us/en/men//element(*, cq:Page) order by @jcr:created */ order by [jcr:created] union(*)select [jcr:path], [jcr:score], * from [cq:Page] as a where isdescendantnode(a, '/content/we-retail/us/en/women') /* xpath: /jcr:root/content/we-retail/us/en/women//element(*, cq:Page)order by @jcr:created */ order by [jcr:created]; expected:

http://localhost:4502/crx/de/index.jsp

if i remove "group.3_path=/content/we-retail/us/en/women" and "group.4_path=/content/we-retail/us/en/equipment" from query it's working fine, any suggestion??

Execution Info:

N/A

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

Hi,

I was able to reproduce your issue in AEM 6.3. However, I had installed SP 6.3.2 and re-ran the same query again. It worked for me after installing the service pack.

Please take a look at old forum question (same issue as yours) - https://forums.adobe.com/thread/2384937. They were able to resolve the issue after installing hotfix aem-6.3.0.

I hope this should resolve your issue as well.

Regards,

Lavanya Malyala

5 replies

A
Anonymous
Accepted solution
June 26, 2019

Hi,

I was able to reproduce your issue in AEM 6.3. However, I had installed SP 6.3.2 and re-ran the same query again. It worked for me after installing the service pack.

Please take a look at old forum question (same issue as yours) - https://forums.adobe.com/thread/2384937. They were able to resolve the issue after installing hotfix aem-6.3.0.

I hope this should resolve your issue as well.

Regards,

Lavanya Malyala

R
rayow4694015Author
June 26, 2019

Thanks for the answer lavanya

i'll try installed the higher one AEM Cumulative Fix Pack 6.3.3.4, hope it's works

A
Anonymous
June 26, 2019

It should ideally work for you as well. If not, do let me know. I'll be more than happy to help!

Regards,

Lavanya Malyala

R
rayow4694015Author
June 26, 2019

i have succesfully install but still any dependencies that could be installed, should i ignore it or i must find the package because when i click install the error message appear

arunpatidar
Community Advisor
arunpatidarCommunity Advisor
Community Advisor
June 26, 2019

Please try below query in 6.3

type=cq:Page

group.1_path=/content/we-retail/us/en/experience

group.1_path.self=true

group.2_path=/content/we-retail/us/en/men

group.2_path.self=true

group.3_path=/content/we-retail/us/en/women

group.3_path.self=true

group.4_path=/content/we-retail/us/en/equipment

group.4_path.self=true

group.p.or=true

orderby=@jcr:created

p.limit=-1

Arun Patidar
Terms & ConditionsAccessibility statement

Loading footer...