About Sanjay_Girotra

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.

Posts	7
Solutions	0
Karma Given	11
Karma Received	5
Member Since	‎09-19-2014

Online Status	Offline
Date Last Visited	‎02-28-2025 11:09 PM

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

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...