ADQL Reference:


Use the WHERE clause to specify one or more condition expressions separated by logical operators such as ANDOR. 

The WHERE clause uses the following syntax:

[WHERE condition_expression] 

See ADQL Expressions for a description of the condition expression syntax. Condition expressions use Comparison Operators.


To filter logs based on error or warning log level, use a query similar to the following:

SELECT * FROM logs WHERE sourceType='yourLogFile' AND (logLevel=’ERROR’ OR logLevel=’WARN’)