ADQL Reference:


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]]...}

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


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.