Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 5.3

SET

TQL includes provision for providing "hints" which may change the way in which a TQL query is handled - hints are specified via the SET statement, which must precede the TQL query.

Currently two hints are supported:

  • TimeZone
  • Index

One or more hints are specified in front of a TQL query, each hint followed by a semi-colon, here is an example of a single hint:

Code Block
languagenone
SET TimeZone="America/New_York"; CreatedAt > 2012-1-2

And here is an example of multiple hints:

Code Block
languagenone
SET TimeZone=Pacific/Auckland; SET Index=Run; Text ~ reports

SET Index

The index hint allows changing the Index being used to process the query.

Note: Currently the Index hint is available for 3rd party developers, and we do not recommend end-users rely on its existence in future versions of Enterprise Tester.

SET TimeZone

This hint allows you to override the TimeZone being used for parsing dates and times, and for handling of calculations such as grouping by day, week or month.

The TimeZone value must be either an IANA zone key, or a Windows Timezone ID.

You can find further details of time zone support within Enterprise Tester, in the Time Zones API help topics.

Note: If a timezone is not specified, then the browser's timezone will be used, or if executing a query via the API, the ET server's configured timezone will be used.