Hi!
Actually there is an error in query used in function. Query looks like
SELECT max(coalesce(cast(idata_value as float),0)) FROM idata_%u
WHERE item_id=? AND (idata_timestamp BETWEEN ? AND ?) AND isnumeric(idata_value)
but isnumeric returns int, not boolean, so it should be
isnumeric(idata_value)=1
I've fixed it. PLease let me know if you need intermediate server build with this fix.
Best regards,
Victor
Actually there is an error in query used in function. Query looks like
SELECT max(coalesce(cast(idata_value as float),0)) FROM idata_%u
WHERE item_id=? AND (idata_timestamp BETWEEN ? AND ?) AND isnumeric(idata_value)
but isnumeric returns int, not boolean, so it should be
isnumeric(idata_value)=1
I've fixed it. PLease let me know if you need intermediate server build with this fix.
Best regards,
Victor
