cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Not a customer? Start a free trial

Click the Start a free trial link to start a 15-day SaaS trial of our product and join our community as a trial user. If you are an existing customer do not start a free trial.

AppDynamics customers and established members should click the sign in button to authenticate.

Business iQ (Analytics)

Analytical ADQL query

SOLVED

Analytical ADQL query

I am looking for an analytical query to fetch list of URLs from browser records that does not match a pagename  with http and without http and with partial URL segments...

 

example : select * from browser records where pagename is not in ("abc.com", "https://abc.com",%abc.com%) 

 

 

Tags (1)
By replying you agree to the Terms and Conditions of the AppDynamics Community.
Analytical ADQL query
1 REPLY 1
Mario.Morelli
Architect

Re: Analytical ADQL query

Hi @Rathinakararaj.Sundaraj 

 

Can you not use something like below?

 

SELECT * FROM browser_records WHERE pagename not like "*abc.com*"

 

Ciao



Learn more about me in the Community Member Spotlight Q & A