Hi Guys,
I do have a class where one it's fields is defined as %TimeStamp and I did query to select all records and if current datetime is bigger then what's in my nextScheduled filed and basically with this condition below I should have all records stored in ^badis but for some reason I'm only getting the first record
S sql="Select ID,CollectTimeOut,KitId,ComponentId,Loc,IntervalValue,IntervalType,LastScheduled,NextScheduled,Schedule,StartDate,StartTime,SensorId,SensorType from MSDS_Common.JobSchedule"
Set RSet=##class(%ResultSet).%New()
Set Ret=RSet.Prepare(sql)
Set Ret=RSet.


.png)
.png)
.png)
.png)


.png)


.png)
