This page describes ADQL query syntax. ADQL uses the SELECT statement and filtering statements, otherwise referred to as queries, to return sets of data that you can add to Custom Dashboards. 

ADQL search queries have a 5,000 character limit and reserve keywords in certain field names or milestones.

Reserved ADQL Keywords
SELECT
FROM
WHERE
ORDERBY
AND
OR
EXISTS
NOT
LIKE
REGEX
COMPARE
LIST
IN
BETWEEN
COUNT
DISTINCT
MIN
MAX
STATS
SUM
AVG
STDDEV
FILTER
PERCENTILE
RANGE
SERIES
SUBSTRING
INDEXOF
LENGTH
TRIM
CONCAT
NOW

The query syntax is: 

SELECT * | {[DISTINCT] expression [AS alias] [, expression [AS alias]]...}
FROM event_type
[WHERE condition_expression] 
[SINCE timevalue [UNTIL timevalue]]
[HAVING condition_expression]
[ORDER BY {field_name | alias} [ASC | DESC] [, {field_name | alias} [ASC | DESC]]...]
[LIMIT integer [, integer]...]
CODE

While the SELECT and FROM clauses are required, all other clauses are optional. Enter spaces around each keyword.

For GROUP BY functionality, see GROUP BY.

Search with Partial Text Strings

To prevent tokenization of messages and text-type strings, prefixes must be added to wildcards when you search with partial text strings. 

The following ADQL query uses a partial text string to search for the word example: 

SELECT * FROM logs WHERE message = "*xample"
CODE