WHERE Clause

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

The WHERE clause uses the following syntax:

[WHERE condition_expression]

CODE

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

AppDynamics recommends that you do not use periods (.) in the field name, otherwise, the syntax will break.

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’)

CODE