sort pages by cq:lastReplicated | Community
Skip to main content
A
Anonymous
October 16, 2015
Solved

sort pages by cq:lastReplicated

  • October 16, 2015
  • 5 replies
  • 2484 views

Hi All,

I am using cq 5.6.1 and I need to sort a list of cq:Page by cq:lastReplicated date property. I want to know whats the best possible way. Also, I need to do this sorting in java class.

Thanks in advance,

Ankit

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by JitendraBansal

You can use QueryBuilder API for this.


        ResourceResolver my_resourse_resolver;
        Session my_session;
        QueryBuilder my_builder;
        Map<String, Object> my_map;
        PredicateGroup my_predicate_group;
        Query my_query;
        SearchResult my_search_results;


        my_resourse_resolver = a_request.getResourceResolver();
        my_session = my_resourse_resolver.adaptTo( Session.class );
        my_builder = my_resourse_resolver.adaptTo( QueryBuilder.class );

        my_map = new HashMap<String, Object>();
        my_map.put( "path", a_path );
        my_map.put( "type", "cq:Page" );

        // Define sort order

        my_map.put( "orderby", "@" + jcr:content/cq:lastReplicated);
        my_map.put( "orderby.sort", "desc" );

        my_predicate_group = PredicateGroup.create( my_map );

        my_query = my_builder.createQuery( my_predicate_group, my_session );
        my_query.setHitsPerPage( a_page.getMaxResults() );
        my_search_results = my_query.getResult();

      
     

5 replies

J
JitendraBansalAccepted solution
Level 2
October 16, 2015

You can use QueryBuilder API for this.


        ResourceResolver my_resourse_resolver;
        Session my_session;
        QueryBuilder my_builder;
        Map<String, Object> my_map;
        PredicateGroup my_predicate_group;
        Query my_query;
        SearchResult my_search_results;


        my_resourse_resolver = a_request.getResourceResolver();
        my_session = my_resourse_resolver.adaptTo( Session.class );
        my_builder = my_resourse_resolver.adaptTo( QueryBuilder.class );

        my_map = new HashMap<String, Object>();
        my_map.put( "path", a_path );
        my_map.put( "type", "cq:Page" );

        // Define sort order

        my_map.put( "orderby", "@" + jcr:content/cq:lastReplicated);
        my_map.put( "orderby.sort", "desc" );

        my_predicate_group = PredicateGroup.create( my_map );

        my_query = my_builder.createQuery( my_predicate_group, my_session );
        my_query.setHitsPerPage( a_page.getMaxResults() );
        my_search_results = my_query.getResult();

      
     

A
Anonymous
October 16, 2015

Hi Jitendra,

Thank you for your inputs.

1) I want to fetch the pages based on three properties as well. cq:template, a custom page property and offTime.

2) How do I just sort a list if I already have a list of cq:pages and all I am looking for is just the sorting part.

Thanks in advance,

Ankit

J
Adobe Employee
JustinEd3Adobe Employee
Adobe Employee
October 16, 2015

If you have a list and you want to sort it, use Collections.sort(). http://docs.oracle.com/javase/6/docs/api/java/util/Collections.html#sort(java.util.List, java.util.Comparator)

A
Anonymous
October 16, 2015

Thank you for your inputs Justin, I had thought of this option earlier but did not look much further into this since I was not sure how to write a comparator for this. So was looking for something CQ specific if it has any. However, do you have any pointers on the first point ?

Ankit

J
Adobe Employee
JustinEd3Adobe Employee
Adobe Employee
October 16, 2015

Take a look at http://docs.oracle.com/javase/tutorial/collections/interfaces/order.html. That explains how to write a Comparator.

Terms & ConditionsAccessibility statement

Loading footer...