Hi, I'm not sure this question relates to xwiki, but it seems you could do something like "order by rand()". I never tested it Br, Jeremie Le 17 juil. 2014 22:55, "Danilo Oliveira" <[email protected]> a écrit :
Hello XWiki Devs,
I have a specific class in the XWiki (TestClass) with more than 50 items. However I would like to retrieve, through the HQL statement, just 5 random results.
I know how to set the limit, using the "setlimit", however I don't know and I did not find if there is a way to retrieve a random result.
Is it possible, or I will need to make a hql that returns all results and after that take 5 itens randomly?
Thanks
-- Danilo Amaral de Oliveira Engenheiro de Computação celular (32) 9111 - 6867 _______________________________________________ devs mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/devs