PDFs

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The field_expression can take several forms. See ADQL Expressions for a description of the syntax and rules.

Examples

QueryResult
SELECT count(transactionName) FROM transactions WHERE application='yourAppName'Returns a count of business transactions for the specified application.
SELECT * FROM logs WHERE sourceType='yourLogFile' AND message LIKE 'GET'Returns log events containing a specified keyword.
SELECT * FROM transactions WHERE application='yourAppName'  AND transactionName='yourBTNameReturns all fields for business transactions in the specified application matching the specified transaction name.
SELECT DISTINCT transactionName FROM transactions WHERE application='yourAppName'Returns a list of unique transaction names from the specified application.
SELECT customerName AS "First And Last Name", age AS "Years Old", ...Returns the specified fields relabeled as specified in the query statement. In this query, customerName and age are user-defined fields.