Reverse tracking SQL

24 May 2018

Senior Principal Engineer at FICO

+ 12

in Community Rank

I've had this issue a few times too, or when you look at deadlocked queries in SQL Server Management Studio or whatever... I can USUALLY find them, but only because I've memorized the whole application, but that's not really effective in most cases... :D

J.Ja

Stoyan Garbatov

25 May 2018

Stoyan Garbatov

Senior Software Engineer at OutSystems

#212

in Community Rank

Changed the category to Database

14 Jul 2018

Senior Principal Engineer at FICO

+ 12

in Community Rank

Merged this idea with 'Add comment on Queries with espace and action to easily find them in Service Studio' (created on 12 Jul 2018 16:02:56 by Diogo Nesbitt)

Diogo Nesbitt

12 Jul 2018

Diogo Nesbitt

Partner at MySports - AluguerDeCampos.com

+ 1

#289

in Community Rank

It's very painful to find the query on service studio, from data received from database, or database performance analysis software.

In our case, the DBA send us an SQL generated by an application, to be improved by developers. But its not easy find the espace where the SQL is. We have more than 600 espaces and we spend hours finding each statement.

If the platform add a simple comment in the beginning of each query it sends to the database with that information, we could easily find it.

Example : /* EspaceX - ActionY - QueryNameZ */

Merged from 'Add comment on Queries with espace and action to easily find them in Service Studio' (idea created on 12 Jul 2018 16:02:56 by Diogo Nesbitt), on 14 Jul 2018 14:18:29 by Justin James

Pradeep Dubey

13 Jul 2018

Pradeep Dubey

Senior Technical at Sewells MSXI

+ 3

#2 242

in Community Rank

Yes, This idea would be helpful as we often face the same problem

Dário Duarte

13 Jul 2018

Dário Duarte

#6 377

in Community Rank

That would be a great improvement.

Vasco Pessanha

13 Jul 2018

Vasco Pessanha

IDE Product Owner at OutSystems

+ 3

#65

in Community Rank

Changed the category to Aggregates & Queries

Tiago Leão

25 Nov 2018

Tiago Leão

Senior Product Owner at OutSystems

+ 2

#572

in Community Rank

Changed the category to Aggregates & Queries

Fernando Moitinho

9 Jan

Fernando Moitinho

Product Owner at OutSystems

+ 1

#85

in Community Rank

Changed the status to

Implemented

on 07 Jan 2019

Hi Neil Munro,

I'm glad to announce that this feature is available on version 10.0.912 and forward.

To enable this capability you need to install the new version of Factory Configuration forge component and check the option "Allow Comment With Query Path". After enable this feature you will have to publish any module that you would like to trace back where in the code the query is located.

This will add a comment on the executed SQL with a breadcrumb of the query location (module -> Service/Server/Screen action).

Thanks for the feedback and hope this fulfill your use case.

29 Jan

DevOps Employee at Vopak

#1 515

in Community Rank

Thanks, sounds good. I was about to try this, but wasn't able to find the flag. Turns out that it needs to be on Platform Version 11.0.127.0 for the flag to be visible.

Oh well, time to schedule another Platform update sometime soon then!

31 Jan

Senior Software Engineer at OutSystems

#1 620

in Community Rank

Hey Sander,

Which O11 version are you using?

For version O10, it is available on 10.0.912 onward.

For version O11, you are right, it is only available on 11.0.127.0 onward. Sorry for not specifying it!

Regards

31 Jan

DevOps Employee at Vopak

#1 515

in Community Rank

Hi Lara,

We recently did upgrade all of our environments to 11.0.108.0, so unfortunately it's not yet available here. Once we do upgrade, we are definitely going to enable it. Sounds very useful!

Kind regards,

Sander

31 Jan