cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

420
Views
5
Helpful
4
Replies
Beginner

Is there a way to know the sql query that the ccx report use?

Hello, 

 

I'm new with CCX and also with Informix, I want to know if there's any chance to see what is the query that the CCX report use when you click on the 'run' button. 

 

When i open the database at DBeaver for example, I can see all the tables and make SELECTS, but I can't see what is the SELECT made when I generate the Abandoned Call Detail Activity Report at the CCX. 

 

Can anyone help me with this please? 

 

Thanks!

Bruna Toledo. 

 

1 ACCEPTED SOLUTION

Accepted Solutions
VIP Advisor

Re: Is there a way to know the sql query that the ccx report use?

It's actually really easy, after you run the report once, click on the SQL button (between Filter and Refresh). From there, it sounds like you've already connected to the DB with DBeaver (never heard of that), and so you should be all set.

Anthony Holloway

If you found this post helpful, please consider clicking that helpful button!

And for a limited time, by marking helpful posts, you're also helping Doctors Without Borders

View solution in original post

4 REPLIES 4
VIP Advisor

Re: Is there a way to know the sql query that the ccx report use?

It's actually really easy, after you run the report once, click on the SQL button (between Filter and Refresh). From there, it sounds like you've already connected to the DB with DBeaver (never heard of that), and so you should be all set.

Anthony Holloway

If you found this post helpful, please consider clicking that helpful button!

And for a limited time, by marking helpful posts, you're also helping Doctors Without Borders

View solution in original post

Beginner

Re: Is there a way to know the sql query that the ccx report use?

Hi Anthony!

 

That was an easy one! ahahaha Thanks a lot :) 

VIP Advisor

Re: Is there a way to know the sql query that the ccx report use?

You're welcome!  It looks like you might be doing some custom reporting, is that right?  And this must be your first adventure with it, correct?  Best of luck to you.


Anthony Holloway

If you found this post helpful, please consider clicking that helpful button!

And for a limited time, by marking helpful posts, you're also helping Doctors Without Borders
Highlighted
Beginner

Re: Is there a way to know the sql query that the ccx report use?

Hi!

You're totally right! My first custom report and my first adventure with CCX! 

Thanks for everything and luck to both of us :) 

 

Bruna Toledo. 

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here