1
 Follower
9
 Likes

SQL Query tool for the Service Studio

Service Studio
Out of the scope

I would be nice to have SQL Query tool for the Service Studio.  

  • This tool should be also optimized for OutSystems entities only.
  • When you go as new developer at old project, it would be many times handy to browse data directly with SQL tool instead of use Aggregate.
  • It should also allow do all the basic database operations like INSERT, UPDATE, SELECT, DELETE, DROP AND CREATE etc.
  • Tool should be also easy or easier as Aggregate :) with SQL export support.

Why:

  • Currently, when you are at environment that you do not have SQL access is a little bit pain and you end up loosing time,


Created on 20 Nov 2018
Comments (13)

Hi Sampsa,


You already have a SQL widget that alows you to do your queries.



Regards,

Abílio Matos

Hi Abilio, I know and I have used those do for DB specific tasks. 

It seems to current way to do things, but using those are slower than I would just have SQL tool for it. 

One of the core messages of the OutSystems is a productivity and SQL Query tool would bring that on many cases.

If you are on the PaaS offering you can request direct SQL access to your databases. We find this to be extremely handy and alleviates the need to build something as powerful as SSMS into Outsystems studio. 

There are limits to the access you have this way, for example you can view and modify your data but you can't update schema etc.


John, that is good to know. The case that I'm working on this week is just so schedule wise so short that Integrated SQL Query tool would have really saved my time.

Good Idea
Should be really nice a simple tool do perform some query more easily without the need to define the output and be able to export the result without you have to install additional tools where you need to setup the Outsystems database connections.
Every developer has some needs sometime to query some tables as well during the working.
Maybe a small icon on Data tab that open a new window to allow you do it.

Again, I have a use case. Where I'm at environment and I need to do some data cleaning. No direct SQL access:

I need to create now Aggregates to fetch correct rows .. oh no .. I have too much data even though I did already filter by user. I need to do still more specific filtering. I just need to find out primary keys for these three rows and delete those, but doing that requires too many steps with aggregates etc. aarggh

The tool would be great also if you could schedule SQL scripts on deploy.

If you have a customer with a Sentry, you are not allowed to connect with Database Magement Tool for SQL data conversions, etc..

Changed the category to Service Studio


Changed the status to
Out of the scope


Hey Sampsa,

There is already a workaround for this, using testquery and aggregates preview, and we don't want to bring all the complexity of these external tools to Service Studio (this would also be a problem in some of our customers, for example using Sentry).

Because of this we don't have plans to tackle this.

Thanks for your feedback!


Merged this idea with 'Provide the option to perform basic CRUD operations in an Aggregate And Advanced SQL View' (created on 06 Dec 2018 12:21:18 by Kadir Özcan)

Hello everybody,

Currently it is not possible to create/update/delete records in place in the data view section of an aggregate or in an advanced SQL query. For example, if I want to quickly add some (test) data to my table for testing out my query, then I must write a separate query to do that.

It would be helpful to be able to do this for example from a context menu option. It would be very nice to see this in Outsystems.



This comment was:
- originally posted on idea 'Provide the option to perform basic CRUD operations in an Aggregate And Advanced SQL View' (created on 06 Dec 2018 by Kadir Özcan)
- merged to idea 'SQL Query tool for the Service Studio' on 31 Dec 2018 09:44:40 by Vasco Pessanha

Here is an example:



This comment was:
- originally posted on idea 'Provide the option to perform basic CRUD operations in an Aggregate And Advanced SQL View' (created on 06 Dec 2018 by Kadir Özcan)
- merged to idea 'SQL Query tool for the Service Studio' on 31 Dec 2018 09:44:40 by Vasco Pessanha

Actually, this should be part of SQL query tool (if there would be one).

https://www.outsystems.com/ideas/5903/sql-query-tool-for-the-service-studio




This comment was:
- originally posted on idea 'Provide the option to perform basic CRUD operations in an Aggregate And Advanced SQL View' (created on 06 Dec 2018 by Kadir Özcan)
- merged to idea 'SQL Query tool for the Service Studio' on 31 Dec 2018 09:44:40 by Vasco Pessanha
views
290
Followers
1