multiple orderby querybuilder in 6.2

Avatar

Avatar
Boost 5
Level 2
keehwan1
Level 2

Likes

5 likes

Total Posts

31 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Give Back 3
Applaud 5
Validate 1
Ignite 3
View profile

Avatar
Boost 5
Level 2
keehwan1
Level 2

Likes

5 likes

Total Posts

31 posts

Correct reply

0 solutions
Top badges earned
Boost 5
Give Back 3
Applaud 5
Validate 1
Ignite 3
View profile
keehwan1
Level 2

31-01-2017

Hello,

This query in 5.6.1 or below works fine. But not work properly in 6.2.

The number of search result is same but ,the result order is wrong in 6.2.

I test in http://server:4502/libs/cq/search/content/querydebug.html

As you see, we use multiple orderby.

 

path:/content/data/contacts
type:cq:Page
2_prop.value:33
2_prop:contactinfo/DEPTID
1_prop.operation:like
1_prop.value:/content/data/organizations/173%
1_prop:contactinfo/ORGANIZATION_PATH
orderby:@contactinfo/@LASTNAME_STRIP, contactinfo/@FIRSTNAME_STRIP

Any help is appliciated.

Keehwan

View Entire Topic

Avatar

Avatar
Boost 50
Level 10
Sham_HC
Level 10

Likes

161 likes

Total Posts

2,114 posts

Correct reply

1,204 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Level 10
Sham_HC
Level 10

Likes

161 likes

Total Posts

2,114 posts

Correct reply

1,204 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
Sham_HC
Level 10

31-01-2017

  • Make sure index defnition is updated with orderby for both the properties. More details refer https://docs.adobe.com/ddc/en/gems/oak-lucene-indexes.html
    • slide 14 has sample index defnition for order by.
  • Two @ is not valid (@contactinfo/@LASTNAME_STRIP)   just use contactinfo/@LASTNAME_STRIP
  • Install the latest service pack

Above changes will work if not file an official support request by attaching

[A]

org.apache.jackrabbit.oak.plugins.index

org.apache.jackrabbit.oak.query

com.day.cq.search