JCR results order by random or every query must give...

[v1101]

Team,

I had another query opened but I was closed.

 how to query JCR to get results in random order. For every query of JCR, the results should be in random order. Like in SQL where there is order by rand(). Could someone help with this.

path=/content/we-retail
1_property=sling:resourceType
1_property.value=summer/components/page/activities
1_property.operation=like

The order by is not by a specific field but by random number.

Thanks.

[Vaibhavi_J]

Hi @v1101 , 

jcr queries doesn't have option for randomizer but you have an option to achieve the outcome using collection. Because jcr result set is a collection and in collection you have option to shuffle the result. 

Please check the below thread for more details. 

https://experienceleaguecommunities.adobe.com/t5/adobe-experience-manager/retrieve-random-images-fro...

[BrianKasingli · Accepted solution]

@v1101, 

Please try with the code provided:

PredicateGroup group = new PredicateGroup();
group.add(new Predicate("mypath", "path").set("path", "/content"));
group.add(new Predicate("mytype", "type").set("type", "nt:file"));
Query query = queryBuilder.createQuery(group, session);
if (query != null) {
    List<hit> list = result.getHits();
    Collections.shuffle(list);
}

[SundeepKatepally]

Order isn't guaranteed.

The default search implementation of Apache Lucene returns results sorted by score (the most relevant result first), then by id (the oldest result first).

Apache Lucene - Scoring