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

viki1101

05-08-2020

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.

 

 

Accepted Solutions (1)

Accepted Solutions (1)

BrianKasingli

MVP

06-08-2020

@viki1101

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);
}

 

 

Answers (2)

Answers (2)

SundeepKatepally

06-08-2020

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

Vaibhavi

MVP

05-08-2020

Hi @viki1101 , 

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...