multiple orderby querybuilder in 6.2

Question

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.htmlAs you see, we use multiple orderby. path:/content/data/contactstype:cq:Page2_prop.value:332_prop:contactinfo/DEPTID1_prop.operation:like1_prop.value:/content/data/organizations/173%1_prop:contactinfo/ORGANIZATION_PATHorderby:@contactinfo/@LASTNAME_STRIP, contactinfo/@FIRSTNAME_STRIPAny help is appliciated.Keehwan

Sham_HC · Accepted Answer

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

Package with index defnition
Debug output of [A] . https://docs.adobe.com/docs/en/aem/6-0/deploy/upgrade/queries-and-indexing.html#Troubleshooting%20indexing%20issues

[A]

org.apache.jackrabbit.oak.plugins.index

org.apache.jackrabbit.oak.query

com.day.cq.search

smacdonald2008 · Answer

Checking to see if this is normal functionality in 6.2 or a known issue.

Sign up

Login with SSO

Login to the community

Login with SSO