Splunk AppDynamics SaaS Analytics ADQL Reference ADQL Queries Current: WHERE Clause PDF Download PDF Download page WHERE Clause. Current page All pages WHERE Clause OverviewUse 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. ExamplesTo 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 ×
