Sorting a list of ArrayList by date in the ArrayList

Question

I have a list of ArrayList, and each arraylist consists of a date and a string. I want to sort the list according to the date in the arraylist. I tried looking for answers but cant find it online. Most of the examples are sorting a list of objects by date. Any suggestions?

public List<ArrayList> SuggestionReport() {
    Query q = em.createQuery("SELECT s FROM SuggestionEntity s");
    List<ArrayList> report = new ArrayList();
    for (Object o : q.getResultList()) {
        suggestionEntity = (SuggestionEntity) o;
        ArrayList suggestion = new ArrayList();
        suggestion.add(suggestionEntity.getSuggestionDate());
        suggestion.add(suggestionEntity.getContent());
        report.add(suggestion);
    }

    return report;
}

ps. I want to sort the list before returning the list

you can query by date.try this sql "SELECT s FROM SuggestionEntity s order by s.suggestionDate desc".the "s.suggestionDate" is your database field .than the result was sort already. — Blade Master
– Blade Master, Commented Oct 12, 2013 at 8:38

Suresh Atta · Accepted Answer · 2013-10-12 08:46:39Z

4

Need not to write extra code, Just change your query to

SELECT s FROM SuggestionEntity s order by  suggestion_date ASC|DESC

Where suggestion_date is your column name.

ASC|DESC is order you want, choose ASC or DESC based on your requirment.

Learn more here about order by

edited Oct 12, 2013 at 8:46

answered Oct 12, 2013 at 8:38

Suresh Atta

122k38 gold badges206 silver badges315 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ayampenyet Over a year ago

Thanks alot!! But this is applicable to java ejb query as well right?

Suresh Atta Over a year ago

Ofcourse, It supports sql right ? Syntax might change. But concept is same. :)

ayampenyet Over a year ago

Thanks a lot for the help! Appreciate it :)

Vova Pronyshyn · Accepted Answer · 2013-10-12 08:38:45Z

0

You should write your own comparator, and then sort it like following:

Collections.sort(list, myComparator);

answered Oct 12, 2013 at 8:38

Vova Pronyshyn

313 bronze badges

Collectives™ on Stack Overflow

Sorting a list of ArrayList by date in the ArrayList

2 Answers 2

3 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related