desc\" }}]"我想更改下面的查询条件:type:ams_log AND (alm_source:K*) AND (alm_id:TCS00004OR alm_id:TCS00005 OR alm_id:TCS00007 OR alm_id:TCS00008 OR alm_id:TCS00009 OR alm_id:TCS00010 OR alm_id:TCS0
如果您在所有的插入语句中观察到条件正在改变WHERE TCS.ChamberAvailaBilityDate = DATEADD(DAY,1,@lCurrentDateTime) WHERE TCS.ChamberAvailaBilityDate)
WHERE TCS.ChamberAvailaBilityDate = DATEAD
tcs WHERE tcs.facilityId=:facilityId AND tcs.rentalNumber>:rentalNumber AND tcs.dueDate>:dueDate ANDdueTypeId IN(:dueTypeId) ORDER BY tcs.rentalNumber ").setInteger("rentalNumber", facility.getPeriod(SELECT
SUM(tcs.dueAmo