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)

Is it possible to join tables using AQL?

kyzhou
Builder

Is it possible to join tables using AQL?

I have a table of IDs to Names:

id: name

1: user1

2: user2

3: user3

 

and another table of more data:

id: edu : ......

1 : bachelor : ....

2 : master : ....

3 : phd : ....

 

Is it possible to use AQL to join these two together so I can display the name corresponding to an id in a search?

By replying you agree to the Terms and Conditions of the AppDynamics Community.
Is it possible to join tables using AQL?
11 REPLIES 11
kyzhou
Builder

No, I do not have an EUM license. I was asking for Analytics tables in general.

 

How should we structure a search to select from multiple tables? Do they need to share the exact same rows, or just a subset?

Chitra.Lal
AppDynamics Team

Hi Kyzhou,

 

As you don't have an EUM license hence this 401 error you see. You need to have EUM license to use browser_records and synth data. 

 

Now regarding your original query we can not select data to be shown from multiple tables unless they are from the same schema. Iff two tables that you are trying to see are in the same schema can you structure a query to fetch data combining both, but not in any other case. 

 

Hope that clarifies. Do let me know in case you have further queries. 

 

Thank You,

Chitra



Found something helpful? Click the Accept as Solution button to help others find answers faster.
Liked something? Click the Thumbs Up button.