我使用bookshelf js构建了一个查询。当我在查询中使用
orWhere
时,会出现错误。
下面是我的代码:对象没有方法"orWhere"。
var filters = {};
// Restaurnat id is must
if (restaurant_id != undefined) {
filters.restaurant_id = restaurant_id
} else {
res.json({
status: 422,
message: "No restaurant id provided",
data: ""
});
}
var query = dp.CusOrder.query('where', filters);
if (customer_name != undefined) {
var first_name = '%' + customer_name + '%';
query.where('first_name', 'LIKE', first_name)
.orWhere('last_name', 'LIKE', first_name);
}
query.fetchAll()
.then(function(result) {
res.json({
data: result
});
});