Skip to Content (Press Enter)
Back to Ideas
39
Like
Follow Idea
SQL Input Parameters Automatically Fill In
2083Views
16Comments
New
Aggregates & Queries

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

23 Mar 2014
Copy link to comment

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!

27 Apr 2018
Copy link to comment
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)
18 Oct 2019
Copy link to comment
UserImage.jpg
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
20 Jun 2018
Copy link to comment
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
09 Jul 2018
Copy link to comment
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
09 Jul 2018
Copy link to comment
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)
18 Oct 2019
Copy link to comment

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
15 May 2019
Copy link to comment
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
27 May 2019
Copy link to comment

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.

18 Oct 2019
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Changed the category to
Aggregates & Queries
26 Jan 2021
Copy link to comment
Merged this idea with 'Sql Advanced querys Test Values' (created on 13 Sep 2019 15:54:45 by Alexandre Santos)
12 Jun 2024
Copy link to comment

Hi guys, hope you all good,


I was thinking about adding a default value to test inputs of SQL advanced querys.

For example, when the developer double click on the SQL advanced query, the static entities should be filled automatically, depending on what is defined on the input variables, and in case the developer double click on the SQL query refresh data, it auto fills the inputs with the different values.

In fact, there is very particular cases that are pretty hard to auto fill like conditions, or even inputs that get information from Session Variables, but, just adding the static entities, in a long term, could save a lot of time testing big querys :)


Best Regards,

José Santos.

13 Sep 2019
Copy link to comment
2018-10-29 13-00-29
Magda Pereira
Changed the category to
Aggregates & Queries
16 Sep 2019
Copy link to comment
Merged this idea with 'Automatically populate Test inputs of Advanced SQL with constants used in the actual call' (created on 11 Jun 2024 07:36:48 by Igor Kirtak)
12 Jun 2024
Copy link to comment

In Advanced SQL, you often need to pass constants (static entity identifiers) as query parameters. Then, when you want tot test the query and go to "Test inputs", it would be nice to have those already populated with the same values, as there is low chance you would want them different. This would also be consistent with Aggregates, where this happens naturally, as static entity parameters are not even shown as parameters.

Currently, not only such parameters in Advanced SQL are initially empty, they are not even saved if you save the module (which might be not intended though), so you need to always set them before testing the query.

11 Jun 2024
Copy link to comment
Changed the status to
New
05 Dec 2025
Copy link to comment