4
 Followers
31
 Likes

SQL Input Parameters Automatically Fill In

Debugger
On our radar
Hello,

I currently work with version 8 of the OutSystems software and noticed something that could be improved. Not sure if someone suggested this idea already but here it goes:

When in debug mode, every time I am analyzing an SQL object, there are times I need to test it. Unfortunately in debug mode I must manually insert all input variables before hitting the test button. In simple websites/systems this might not be an issue but with complex systems it becomes hard to find out the values of certain parameters.

My suggestion would be for the software to automatically fill in the parameter values based on the current object.

For example:
If I am currently analyzing object A and the SQL query needs this object's ID then it would be filled automatically so I can just hit the Test button instead of me searching for it.

Keep up the good work!

Regards,
Ricardo de Freitas
Created on 23 Mar 2014
Comments (9)

4 years later and i don't believe this wasn't implemented yet.

I work as support and this would save us a lot of time and trouble. Please revisit this idea!

Merged this idea with 'Aggregate Data Results in Debug Mode should use Current Variable Values for Test Values' (created on 20 Jun 2018 18:38:45 by PJ M)

I have an Aggregate in Debug Mode. I want to see the data it returns. When I first click it, it says Test Values for filters must be entered, but those test values are currently in variables in the Preparation, fill the test values with THAT data, so I can see exactly what is in the aggregate in this runtime moment.



This comment was:
- originally posted on idea 'Aggregate Data Results in Debug Mode should use Current Variable Values for Test Values' (created on 20 Jun 2018 by PJ M)
- merged to idea 'SQL Input Parameters Automatically Fill In' on 18 Oct 2019 09:00:50 by Kilian Hekhuis

Changed the category to Debugger




This comment was:
- originally posted on idea 'Aggregate Data Results in Debug Mode should use Current Variable Values for Test Values' (created on 20 Jun 2018 by PJ M)
- merged to idea 'SQL Input Parameters Automatically Fill In' on 18 Oct 2019 09:00:50 by Kilian Hekhuis
Changed the status to
Working on it
expected delivery in Q3 2018


Hi PJ M,

Thanks for pointing out this great improvement, we have analysed and is something that we will included on our backlog and work on it in the short future.

We will let you once is available.

Thanks,



This comment was:
- originally posted on idea 'Aggregate Data Results in Debug Mode should use Current Variable Values for Test Values' (created on 20 Jun 2018 by PJ M)
- merged to idea 'SQL Input Parameters Automatically Fill In' on 18 Oct 2019 09:00:50 by Kilian Hekhuis
Merged this idea with 'When we are debugging and we stop at Aggregates or Advanced queries fill test inputs' (created on 15 May 2019 21:50:10 by Romeu Azevedo)

Hi,

A lot of times when we are debugging and we are going to check what is wrong with a query what we do is copy one by one the values on debug to the aggregate or advanced query.

So it will be nice if they are empty, we fill them automatically when we open them.

Thanks 



This comment was:
- originally posted on idea 'When we are debugging and we stop at Aggregates or Advanced queries fill test inputs' (created on 15 May 2019 by Romeu Azevedo)
- merged to idea 'SQL Input Parameters Automatically Fill In' on 18 Oct 2019 09:01:06 by Kilian Hekhuis

Changed the category to Aggregates & Queries




This comment was:
- originally posted on idea 'When we are debugging and we stop at Aggregates or Advanced queries fill test inputs' (created on 15 May 2019 by Romeu Azevedo)
- merged to idea 'SQL Input Parameters Automatically Fill In' on 18 Oct 2019 09:01:06 by Kilian Hekhuis

I merged two ideas into this one, even though they're about Aggregates instead of the original one's SQL, since there were no Aggregates back when the original Idea was entered.

Obviously, it should work for both Aggregates and SQL alike.

views
1182
Followers
4