Search
Generic filters
Exact matches only

Ranges & Dates Site Settings Reference

Ranges and Dates site settings allow you to define custom ranges and actions for everything, including time ranges for data retrieval queries, database time zones, and filter settings. You’ll find Profiles and Dashboards under the Site Settings icon () in the Document Actions panel. These setting apply sitewide.

Chart Ranges

AttributeDescription
Chart Range NameThe name of the Chart Range as it appears to users.
Display OrderThe numeric value that overrides the default alphanumeric order of Chart Ranges. Chart Ranges with blanks will be sorted alphanumerically and displayed below Chart Ranges with numbers.
Start TimeStart of the time range for the Chart Range. (Note: The Start Time must be < the End Time, and the value can be an actual or relative date. e.g. 6/12/2019 or *-7Days).
End TimeEnd time range for the Chart Range. (Note: The End Time must be > the Start Time, and the value can be an actual or relative date. e.g. 6/12/2019 or *-7Days).

Chart Dates

AttributeDescription
Chart Date NameThe name of the Chart Date as it appears to users.
Display OrderThe numeric value that overrides the default alphanumeric order of Chart Dates. Chart Date with blanks will be sorted alphanumerically and displayed below Chart Dates with numbers.
Chart TimeThe chart date used by Charts. This value can be either an actual or relative date (e.g. 6/12/2019 or *-7Days).

Default Ranges

AttributeDescription
Default Range NameRead-only system level name
Start TimeThe Start Time for the Chart Range. (Note: The Start Time must be < the End Time, and the value can be an actual or relative date. e.g. 6/12/2019 or *-7Days).
End TimeThe End Time for the Chart Range. (Note: The End Time must be > the Start Time, and the value can be an actual or relative date. e.g. 6/12/2019 or *-7Days).

Event Ranges

SettingDescription      
ConnectStringConnectString, DSN or Interface that defines the connection to the data source used in the query.
QuerySQL 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 FormatFormatting 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 FormatFormatting 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 ZoneThe 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 IndexColumn index within the resulting table that contains the Start Date.
Result Start End Column IndexColumn index within the resulting table that contains the End Date.
Use Type FilterControls whether or not the query and the UI will contain a drop down for further filtering.
Type Filter LabelControls the label for the optional filtering dropdown. Default name is Type.
Type Filter ValuesSets the predefined values for the filtering dropdown. 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.

Learn more

Configure Profiles and Dashboards Sitewide

Sitewide vs Override Settings

 

Was this article helpful?

Related Articles