Event Ranges
Event Ranges allow you to define custom ranges and actions for everything, including time ranges for data retrieval queries, database time zones, and filter settings. You find the Event Ranges configurations under Site Settings (
) in the Document Actions panel.
| Setting | Description |
|---|---|
| ConnectString | ConnectString, DSN or Interface that defines the connection to the data source used in the query. |
| Query | SQL query or parameters to retrieve data for the event ranges. This query will require 2 parameters {STARTDATE} and {ENDATE} and an optional third parameter called {TYPE}. The results of this query should return event ranges between the passed in Start and End dates (optionally filtered by the {TYPE} parameter). The results must either contain the columns [StartDate or Start Date] and [EndDate or End Date] or contain the start date and end date as the first 2 columns. All columns in the result will be displayed. Requires ConnectString. |
| Query Date Format | Formatting applied to {STARTDATE}, {STARTDATE.Date}, {ENDDATE} and {ENDDATE.Date} parameters passed into the query. If this field is empty windows settings will be used. |
| Query Time Format | Formatting applied to {STARTDATE}, {STARTDATE.Time}, {ENDDATE} and {ENDDATE.Time} parameters passed into the query. If this field is empty windows settings will be used. |
| Database Time Zone | The time zone setting for the database you are querying. Only set this field if the database time zone differs from the web server. |
| Result Start Date Column Index | Column index within the resulting table that contains the Start Date. |
| Result Start End Column Index | Column index within the resulting table that contains the End Date. |
| Use Type Filter | Controls whether or not the query and the UI will contain a pull-down for further filtering. |
| Type Filter Label | Controls the label for the optional filtering pull-down. Default name is Type. |
| Type Filter Values | Sets the predefined values for the filtering pull-down. This should be a semicolon delimited list such as Batch;Shift;Plant or an ordinal|value semicolon delimited list (such as 1|Batch;2|Shift;3|Plant). If you use a ordinal|value list, the ordinal will be passed as the parameter. |
Showing 1 to 10 of 10 entries