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.