No method for random query

[arshad115]

DBFlow Version: 4.2.4

Bug or Feature Request: Feature Request

Description:

DBFlow does not support random query.

In SQLite I would simply write the query as:

select * from table_name ORDER BY RANDOM() LIMIT 1;

I couldn't find anything which is equivalent for it DBFlow.

[agrosner]

Did you try something like .orderBy(Property<Any>(NameAlias.rawBuilder("Random()").build()))?

[arshad115]

Thanks for the reply, but, it does not work with Property<Any>.

[agrosner]

For now, use orderBy(OrderBy.fromString("RANDOM()")) sorry for late reply! I will add a new way in 5.0.0-alpha2

[agrosner]

Now even better, orderBy random will work in kotlin. Java, use .orderBy(Method.random)!