Skip to end of metadata
Go to start of metadata

ADQL Reference:

Your Rating:
Results:
1 Star2 Star3 Star4 Star5 Star
38 rates

Overview

The ADQL event query begins with a SELECT clause, which can take one or more arguments.

SELECT * | {[DISTINCT] field_expression [AS alias] [, field_expression [AS alias]]...}

  • A single asterisk * in the SELECT clause means return the list of fields for each event.
  • To return specific fields for each event, specify a comma-separated list of fields.
    Optionally, each field_expression can be aliased to a label using the AS construct.
  • Use the DISTINCT qualifier to return unique combinations of the specified field values. If no limit specified, the top 10 results by count are returned. See LIMIT Clause.
    DISTINCT can not be applied to a wild card SELECT query, such as 

    SELECT DISTINCT *
  • String values must be surrounded by either single quotes or double quotes, such as 'hello' and "hello".

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.
  • No labels