Node.js - where condition only works as object or inside knex function

btree

Hoi,

seems like this problem was previously discussed, but documentation on homepage needs to be updated accordingly or the problem needs a fix.

(https://datatables.net/forums/discussion/60782/node-js-where-clause-stopped-working-after-updating-knex)

This wont work:

editor.where( 'user_id', 12 );

but the object variant works:

editor.where( {
    user_id: 12
} )

The object variant doesn't allow conditions, so I have to write the function variant as follows:

editor.where( function () {
    this.where( 'user_id', '>', 12 );
} );

Cheers
Hannes

allan

Hi Hannes,

Thanks for pointing that out. It is an error on my part - apologies. I've committed the fix here.

Regards,
Allan

btree

Hi Allan,

awesome thanks as always for the quick fix.

Cheers
Hannes