Bookshelf.js orderby items randomly using rand()

Question

I am using bookshelf.js to develop a project using mariaDB. I want to get my post items ordered randomly. I found this solution works for knex.js

knex('posts').select('id', 'text')
            .orderByRaw('RAND()')
            .limit(100)

But I want to do the same thing with Bookshelf.

user_6878504 · Answer

Maybe this answer will be helpful to someone :

//with where 
    let val = await Question.where({'test_id': id}).query(function (qb) {
                qb.limit(1);//with limit
                qb.orderByRaw('RAND()')//with rand
            }).fetchAll({
                withRelated: ['answers', 'comments'], require: true
            });

Bookshelf.js orderby items randomly using rand()

2 Answers