I need to get random rows using dynamic query

[Ahmed Kamel, módosítva 13 év-val korábban]

I'm using dynamicQuery and i want to get random rows

[Charles de Courval, módosítva 13 év-val korábban]

What ??
You need to be more specific, to give more detail.

[Ahmed Kamel, módosítva 13 év-val korábban]

DynamicQuery dynamicQuery = new DynamicQueryFactoryUtil().forClass(Playlist.class);

List<Playlist> resultList = PlaylistLocalServiceUtil.dynamicQuery(dynamicQuery));


What I need to get random resultList? That is it!!!!!!!

[Charles de Courval, módosítva 12 év-val korábban]

Collection.shuffle( List ) could do the job.

Other wise you'd have to rely on you DB for random results and dynamicQuery won't help you there. You'd have to go with SQL and a FinderImpl class.

[Thomas T., módosítva 12 év-val korábban]

Collection.shuffle( List ) could do the job.

Not really. The list will always contain the same elements but in a different order. What Ahmed Kamel wants is random results. To get this you can use hibernate object

Restrictions.sqlRestriction("order by rand()")

in your query.