Sortby two Values at a time

Hi @kiran_uhc 
You can't sort results based on 2 values, you have to write your own logic and reorder results using java.

@kiran_uhc As per documentation, it should be working. This is what I am referring  to orderby 

Allows the results to be sorted. If ordering by multiple properties is required, this predicate must be added multiple times using the number prefix, such as 1_orderby=first, 2_oderby=second.

Are you certain that these properties exists at the path you are specifying-

predicateMap.put("9_orderby", "@jcr:content/articleDate");
predicateMap.put("9_orderby.sort", "desc");
predicateMap.put("10_orderby", "@articleDate"); -- This can be just articleDate (remove @ prefix). Also the number i.e 9_,10_ etc, ensure they are unique for each predicate and not just for orderby
Please check your properties once again and make some adjustments if needed, you can refer the documentation as well (which is not very detailed but seems to suggest that multiple property sort works).

• https://experienceleague.adobe.com/docs/experience-manager-65/content/implementing/developing/platfo...
• https://github.com/paulrohrbeck/aem-links/blob/master/querybuilder_cheatsheet.md#multiple-ordering

thanks.

Here’s a possible solution leveraging AEM's query API capabilities and custom application logic:

1. Use a single `orderby` predicate that targets the primary date property available on most pages (for example, `@jcr:content/articleDate`).
2. Execute the query to retrieve an initial result set.
3. Post-process the result set in your application code to adjust the sorting by:
- Checking if the `articleDate` property exists on the retrieved nodes.
- For nodes missing the `articleDate` property, use the `@articleDate` page property.
- Create a unified list of nodes with their respective date values.
- Sort this list based on the date values in descending order.

Here is a pseudo-code example of how you might implement this logic:

```java
Map pageDateMap = new LinkedHashMap<>();
for (Hit hit : result.getHits()) {
Node pageNode = hit.getNode();
Calendar date = null;

// Check if the 'articleDate' property exists within jcr:content
if (pageNode.hasProperty("jcr:content/articleDate")) {
date = pageNode.getProperty("jcr:content/articleDate").getDate();
}
// If not, use the 'articleDate' page property
else if (pageNode.hasProperty("articleDate")) {
date = pageNode.getProperty("articleDate").getDate();
}

// Add to a map to keep track of pages and their dates
if (date != null) {
pageDateMap.put(pageNode.getPath(), date);
}
}

// Sort the map entries by their date values in descending order
List> entries = new ArrayList<>(pageDateMap.entrySet());
Collections.sort(entries, new Comparator>() {
public int compare(Map.Entry a, Map.Entry b) {
return b.getValue().compareTo(a.getValue());
}
});

// Now 'entries' contains sorted pages by date in descending order
```

This code snippet assumes that you have a result set from an AEM query and proceeds to sort the pages by their date properties, whether the date is within the `jcr:content` node or directly on the page node.

@kiran_uhc Did you find the suggestions from users helpful? Please let us know if more information is required. Otherwise, please mark the answer as correct for posterity. If you have found out solution yourself, please share it with the community.