Generating SQL query at the beginning of the execution

Michal shared this idea 42 days ago
Awaiting Reply

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.

Comments (1)

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

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

photo
1

Hi Michal,

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

Kind regards,

Nathan Goddard

photo