Hi all,

I'm trying to get a Reporter query from the BASE2.x API which is
basically "ORDER BY RAND(123)" - to get reproducible "random" order (I
can explain *why* in another email if anyone cares to know).

I tried this

DataQuery<net.sf.basedb.core.data.ReporterData> repQuery =

repQuery.order(Orders.asc(new HqlExpression("RAND(123)", "xxx")));

But it seems that HqlExpression isn't for public use.  I can't find
something like "Expressions.hql".
Could somebody please save me a ton of time and tell me how to put
some arbitrary SQL into the ORDER BY clause of a DataQuery?

many thanks,

Don't let slow site performance ruin your business. Deploy New Relic APM
Deploy New Relic app performance management and know exactly
what is happening inside your Ruby, Python, PHP, Java, and .NET app
Try New Relic at no cost today and get our sweet Data Nerd shirt too!
The BASE general discussion mailing list
unsubscribe: send a mail with subject "unsubscribe" to

Reply via email to