STS_HasInterruptedSignal function

The STS_HasInterruptedSignal function indicates whether the object has an interrupted signal for a specified time range.

Syntax

STS_HasInterruptedSignal(
                        ts           TimeSeries,
                        begin_time   DATETIME YEAR TO FRACTION(5),
                        end_time     DATETIME YEAR TO FRACTION(5))
returns Boolean

ts: The time series value.
begin_time: The start of the time range. Can be NULL to indicate the first element in the time series.
end_time: The end of the time range. Can be NULL to indicate the last element in the time series.

Usage

Run the STS_HasInterruptedSignal function to find out whether an object has an interrupted signal for the entire time range. An interrupted signal condition means that the object has missing data and is in a different location.

Returns

t = The object has an interrupted signal for the time range.

f = The object does not have an interrupted signal for the time range.

An exception = An error.

Example

The following query returns whether any vehicles had an interrupted signal between the times of 2014-06-07 20:52:53.00000 and 2014-06-10 16:49:36.00000:

SELECT modid, STS_HasInterruptedSignal(ts_track, 
         '2014-06-07 20:52:53.00000', '2014-06-10 16:49:36.00000') 
         FROM t_vehicle; 

modid                                (expression) 
1001                                           t
1002                                           f 

2 row(s) retrieved.

Vehicle 1001 had an interrupted signal.