Discussion Feed

Sanjay.Girotra · ‎02-21-2020

Thanks for the response Mika. Although it accepted "NOT LIKE", below query worked: SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName NOT LIKE "Equity*". Note the missing Dot in NOT LIKE clause after Equity. So far so good, the follow up question is how to ignore many patterns, say, SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName NOT LIKE "Test*|Equity*|Find*"

Sanjay.Girotra · ‎02-15-2020

Hi, I understand below query is possible: SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName REGEXP "Test-job.*" But is this possible: SELECT count(*) FROM synth_session_records WHERE failureType = "Test location is currently unavailable" AND measurementSpec.scheduleName REGEXP NOT-LIKE "Test-job.*" Refer below docs: https://docs.appdynamics.com/display/PRO45/Analytics+Synthetic+Sessions+Data https://docs.appdynamics.com/display/PRO45/REGEXP+Operator Thanks.

Sanjay.Girotra · ‎02-07-2019

Is there any limit on the # of characters for SQL query? We increased to 2000 and these are still truncated and I have been requested to change to 4000.

Date Registered	‎09-19-2014 12:01 PM
Date Last Visited	‎03-25-2022 09:35 AM
Total Messages Posted	5
Total Kudos Received	1

Discussion Feed

Re: Is it possible to have "NOT LIKE" in ADQLs?

Is it possible to have "NOT LIKE" in ADQLs?

Re: How do I increase the maximum SQL capture leng...