New Topic

Community Topic Idea Report Builder

Mark McGuire

Yellowfin Support Team

Assigned

Category Report Builder

Product Version 7.4

Generating SQL query at the beginning of the execution

Michal shared this idea ago

Idea Logged

Hi,

Currently, when running a query in YF, the SQL code is being generated only after the execution ends or after couple of minutes.

Getting the SQL code at the moment the query start the execution will be very helpful for us - mainly for investigation of slow executions.

I like this idea 0

Replies (1)

Nathan Goddard ●

Hello Michal,

Thank you for sending this idea into us.

I would like to ask a few questions to make sure we have a full understanding of your use case and a rough idea of how you imagine this working within the application.

From you description it sounds like you would be looking for something similar to the 'View Summary' where you can see general information, columns, SQL etc. I believe having something like this at a report level would meet your requirement to be able to see the report SQL with running it as well as including further details about the report such as last run time, average run time etc.

If you believe that this suits your needs please could you confirm and I will get this raised as a enhancement to our development team.

Kind regards,

Nathan Goddard

Reply URL

Michal ●

Hi Nathan,

clarifying the request:

my suggestion is to display the "SQL Statement" immediately when pressing on "Go" .

Currently we allow to see the SQL statement only when the report execution ends - this is problematic for us when we would like to investigate slow execution which don't finish to run on the server.

/e23cbe03fbdf07caea787e863a4ef2cc

Let me know if it's clear now.

Thank you,

Michal

URL

Nathan Goddard ●

Hi Michal,

Thank you for getting back to me. I understand the requirement you are looking, the reason that this SQL is not generated before loading is due to a series of functions that run to make sure that the SQL is valid before it is run, it checks that the tables and fields still exist in the data source.

I believe that it may be better if this was implemented prior to the report being opened as this would then allow you to see this information even in reports that don't have filters or those that have been configured to auto run. Would you be happy with an outcome that looked like the 'View Summary' currently available at the view level?

/a8a165d598150fc6a305c8210b96c29c

Please let me know and I will get this raised with the development team.

Kind regards,

Nathan Goddard

URL

Michal ●

Hi Nathan,

It sounds like a very good solution.

only one thing - I'm not sure were this view will be. can you please share a screenshot?

Thank you,

Michal

URL

Nathan Goddard ●

Hi Michal,

I'm glad you like the idea.

I would be requesting that this window would be accessed by going to the browse list of your reports and clicking the 3 dots. Below is how it currently shows when browsing views.

/ca5e9dc9c59fbd63f1950815aeed6c26

Kind regards,

Nathan Goddard

URL

Michal ●

Hi Nathan,

So if I understood right, in the report is like right click on the report?

It will be added to the list below?

Thank you!

/0f136a20b962cf676367e537aa27f859

URL

Nathan Goddard ●

Hi Michal,

Yes, that would be the suggested location for this new feature.

Kind regards,

Nathan Goddard

URL

Mark McGuire ●

Hi Michal,

I hope all is well,

My name is Mark and I will be taking over this ticket for Nathan... Going forward I will go ahead and raise the below as an enhancement with our development team;

NOTE: The below will be the exact wording I will use for our enhancement.

Option to see the SQL (as well as other information before a report has been executed/run

As it stands we have to run a execute/report a report before we see the SQL, we would like the option to see this before executing/running.

This is possible at view level:

262c48098cc3a4ce75f0ec32e8c4b996

79712bd931dfa6fcd17d20147032d320

However we want this as a Report Summary when selecting the 3 dots at browse level:

6f04777e0ee3ae1d1a1dcd444d18a3ef

Adding this option to the bottom of the list would be great. Despite having just the SQL, we would like to include other relative details, such as last run time, average run time etc similar to the details section when a report has been executed/run.

c58926e6655486104f375ad6072d0804

URL