knex js limit and offset dynamic code example
Example: knex like query
const getResults = (options) => {
let query = knex('table');
if (options.where) {
query = query.where('franchisee_name', 'like', '%jackmarker%');
}
if (options.other) {
query = query.where('company', 'like', '%marker%');
}
return query.select();
};