我执行了以下查询,但是出现了错误。我想要的是我在末尾发布的SQL查询的结果。
userServiceAppointmentModel.findAll({
where: {
technician_id: resultsFromAuthentication.technician_id,
is_confirmed_by_user: 1,
$or: {
service_start_time: {
gte: curLocalDate
},
service_running_status: 1
}
},
attributes: attributes
}).complete(function (err, appointmentResponse) {
if (err) {
console.log(err);
}
SELECT
`id`, `technician_id`, `user_id`, `service_id`, `service_name`,
`service_location_string`, `service_location_latitude`,
`service_location_longitude`, `service_start_time`, `service_end_time`,
`notes`, `total_cost`, `service_cost`, `is_confirmed_by_user`,
`is_confirmed_by_technician`, `service_running_status`,
`service_start_time_by_technician`,`service_complete_time_by_technician`
FROM `user_service_appointment` AS `user_service_appointment`
WHERE `user_service_appointment`.`technician_id`=154
AND `user_service_appointment`.`is_confirmed_by_user`=1
AND (`user_service_appointment`.`service_start_time` >='2015-02-26 01:07'
OR `user_service_appointment`.`service_running_status`=1)
user_service_appointment
.technician_id
=154 ANDuser_service_appointment
.is_confirmed_by_user
=1 ANDuser_service_appointment
.$or
gte
= '2015-02-26 01:07' ANDuser_service_appointment
.$or
1;' }, 我认为问题在Where条件语法上。 - Gurpinderuser_service_appointment
.service_start_time
>='2015-02-26 01:07' ORuser_service_appointment
.service_running_status
=1)。 - Gurpindergte
,它应该是$gte
。如果你仔细看错误,它总是从问题发生的地方开始,gte = ...
它把gte
当作字符串而不是>=
运算符。 - amaster