Configure DataHub Query Parameters

you can configure the query parameters by setting the order of results, applying limits to your query, and specifying the time range for your data queries before you begin ensure that connections have been previously created and are visible in the connection table see define datahub connections docid 6o3gzwf3gm2lwncmekbjw for details familiarity with define datahub queries docid\ omhojznggms4x03zfjeoc and manage datahub queries docid\ ue9j noaslvyfpzdwstmk steps to configure order, limit, and time range parameters this guide discusses three key parameters that you can configure these elements include ordering managing the query order (ascending or descending) limit setting or removing a limit on the query results time range determining the segment of data to query from the table configure order of queries the order by element manipulates the ordering section by default, the ordering is set to ascending to change the order, switch the setting to descending from the drop down menu note this adjustment is directly reflected in the query statement note a query statement is a live display that reflects the user's configuration parameters—like order, limit, and time range—allowing for real time data retrieval from the datahub or external database configure limits of queries the limit parameter is not set by default when a limit is applied, the adjustments become visible in the query statement t he slimit option restricts the number of series returned by a query, similar to how the limit clause restricts the number of points removing respective settings ( limit or slimit ) will hide the respective sections from the query statement configure time range of queries the time range parameter determines the section of the table from which data is queried using the dropdown the litmus datahub queries interface provides preset time frames via a drop down menu these presets are designed to simplify stopping data pull and setting the appropriate time range using the time range editor if a preset does not meet your needs, click the edit ( pencil icon ) button to use the time range editor the default values shown are typically from as minus one hour and to as the current time the from value must always be in the past click the edit ( pencil icon ) next to the from or to input box to change the time unit using a numeric spinner (e g , hours, minutes, seconds, days, weeks, months, or years) this allows precise control over the time span, such as setting the query for the last four hours click the calendar icon next to the edit button to query data requiring a specific date range once applied, the query consistently pulls data from the specified fixed time frame regardless of subsequent updates after defining the time range parameter, click save the saved settings will modify the time range and immediately reflect the changes in the query statement key points to remember it is possible to freeze the from value and let the to value update this approach enables continuous data accumulation, useful for comparative analyses or experiments you can use relative time for dynamic reports that update, such as always pulling data from the last five to eight hours the time range editor provides the option to configure the range into the past or future example to extract data from six to eight when running the query at nine o’clock, adjust the range accordingly