Edit data directly in ViewData editor inside Service Studio
4766
Views
96
Comments
Implemented
Backend
Development Environment Release 109

I would be great to be able to edit entity data (in addition to the ViewData functionality) inside Service Studio. 

As far as I know, there is no easy way to manually edit data for testing purposes. 

This is extremely helpful especially when bootstrapping data from Excel

Changed the category to
Backend

I'm working on a project right now, that was just discussing the requirement for this, so that we could adjust data for the purposes of UAT Testing, when a test fails, to be able to reset the data, and try the test again.  It would also be very handy to look at the data before and after testing, to see what changed.

A basic SQL editor is also nice to have (for simple CRUD operations). The ViewData functionality is great, but sometimes you need to just write and execute a quick SQL command.


  

Merged this idea with 'Run Server Action to update records from some entity directly in Service Studio for dev environment' (created on 14 Nov 2018 17:37:46 by Raphael Ranieri)
Raphael Ranieri
mvp_badge
MVP

Sometimes we have to change some data to test something or because they are inconsistent due any wrong development.


For change that if the table do not have a detail screen we have to create a logic in a timer and execute it, or use a advanced query using commit in the end, which is not very known.


The suggestion is to run a single action directly from service studio with some logic to update these records or do whatever you want, without the need to create a timer or a screen to do that!

Or if not possible to run an action, some way to change the data easily in service studio.
Just for dev environments! 



This comment was:
- originally posted on idea 'Run Server Action to update records from some entity directly in Service Studio for dev environment' (created on 14 Nov 2018 by Raphael Ranieri)
- merged to idea 'Data Editor in Service Studio' on 31 Dec 2018 10:18:17 by Vasco Pessanha

Usefull!



This comment was:
- originally posted on idea 'Run Server Action to update records from some entity directly in Service Studio for dev environment' (created on 14 Nov 2018 by Raphael Ranieri)
- merged to idea 'Data Editor in Service Studio' on 31 Dec 2018 10:18:17 by Vasco Pessanha

Just letting you change the data in sql grid.



This comment was:
- originally posted on idea 'Run Server Action to update records from some entity directly in Service Studio for dev environment' (created on 14 Nov 2018 by Raphael Ranieri)
- merged to idea 'Data Editor in Service Studio' on 31 Dec 2018 10:18:17 by Vasco Pessanha

Good Suggestion



This comment was:
- originally posted on idea 'Run Server Action to update records from some entity directly in Service Studio for dev environment' (created on 14 Nov 2018 by Raphael Ranieri)
- merged to idea 'Data Editor in Service Studio' on 31 Dec 2018 10:18:17 by Vasco Pessanha
Merged this idea with 'Ability to ADD, EDIT and DELETE data in View Data in Service Studio' (created on 03 Jan 2019 13:52:22 by Sienna)

It would be really handy to be able to add, edit and delete data directly in Service Studio via the View Data for entities.



This comment was:
- originally posted on idea 'Ability to ADD, EDIT and DELETE data in View Data in Service Studio' (created on 03 Jan 2019 by Sienna)
- merged to idea 'Data Editor in Service Studio' on 04 Jan 2019 09:13:22 by Vasco Pessanha

I see some functionality here, but also some danger. For this to happen it would need to be restricted by role/permission and at least it would need to "push" the SQL warnings/validations.



This comment was:
- originally posted on idea 'Ability to ADD, EDIT and DELETE data in View Data in Service Studio' (created on 03 Jan 2019 by Sienna)
- merged to idea 'Data Editor in Service Studio' on 04 Jan 2019 09:13:22 by Vasco Pessanha

Hey Marios,

I just tweaked the title of this idea so that it can be found more easily by other community members.

Hope you don't mind.

Cheers,

Good idea Marios. When I added mine the automated search told me that it had not found any other similar suggestions.

Merged this idea with 'Edit Entity data from service studio' (created on 07 Jan 2019 11:27:07 by Mohamed)

It will be convenient if there is an option available in the service studio to insert/update the entity data from the service studio apart from bootstrapping. 



This comment was:
- originally posted on idea 'Edit Entity data from service studio' (created on 07 Jan 2019 by Mohamed)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 07 Jan 2019 11:28:02 by Vasco Pessanha
Changed the status to
On our RadarOn our radar

Hi Marios,

Your idea is now on our radar! 

Thank you so much,

Ângela

Merged this idea with 'CRUD in Service Studio' (created on 23 Sep 2019 03:19:01 by Roman Fal's)

The idea is application developer can Manipulate data (Create, Update Delete) in Service Studio. so the developer no need to create webscreen to manipulate data. 



This comment was:
- originally posted on idea 'CRUD in Service Studio' (created on 23 Sep 2019 by Roman Fal's)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 23 Sep 2019 10:10:29 by Ângela Dinis
Merged this idea with 'Provide feature for edit data directly on Entity like SQL table.' (created on 08 Jan 2020 11:35:55 by Manish Kumawat)

Currently if we want entity with data than we need to define table in excel and than we can import it but the foreign  key relationship is not able to update.

on Right click on entity we can see view Data option. same like this we can have Edit data also like table in sql DB.

It may possible for the enhancement feature for Service studio to edit the data directly click on the Entity.



This comment was:
- originally posted on idea 'Provide feature for edit data directly on Entity like SQL table.' (created on 08 Jan 2020 by Manish Kumawat)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 08 Jan 2020 11:39:06 by Fernando Moitinho
Merged this idea with 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 11:51:35 by Christian Lopes)

Up to very recently, developers were able to write a 'Commit' statement in order to have changes in the database done without publishing, as such:

Although the 'Test' feature is temporary, and rolls the changes back, because there was a commit statement, these changes would be permanent. Which meant a developer could do hot fixes without publishing. 


This ability was removed, probably as a security measure. 

I understand that this may pose a serious risk in Production Environments, but it was already possible to block the test feature entirely, and thus block the 'Commit' injection with it. So before, we had two choices.


Allow the test feature + Commit ; Don't allow the test feature ( which blocks Commit )


Now we have:


Allow the test feature ( But don't allow a commit ) ; Don't allow the test feature.


If security was the main issue, blocking the Test feature itself should solve it right?

Our alternative is to create a screen, and put the hot fixes on actions. Is there any difference between creating a screen, publishing it, running the action, deleting the screen and publishing again; and Testing a query with commit?


Looking forward to hearing from you.



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões
Nuno Reis
mvp_badge
MVP

There is another difference. Allow Testing allows to Test. Delete is not as important as testing queries.

BeforeCan Test QueryCan See DataCan Change Data
Allow TestYesYesYes
Don't Allow TestNoNoNo




NowCan Test QueryCan See DataCan Change Data
Allow TestYesYesNo
Don't Allow TestNoNoNo


I understand you miss that feature (I read it in the forum and heard it on the User Group from several people) but there are different issues here.

You may block Test Data to protect client privacy. That's it. There is awareness that data can't be used.


When you do a Commit, there is no registry on OutSystems of how the data disappeared. The query was tested and deleted. It was a mistake? No one saw.

If you are forced to publish a page/action, you leave a trail. There is awareness that a page exists where data can tampered. Not only you think twice before pressing the Run Query, but the page itself can validate what type of query is running.

For me, that page makes as much sense as the custom CRUD actions where you save dates and users automatically, create a log of interactions and validate the data and the operation.

Some businesses may not need it, but it is a best practice.



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões

Indeed, a trail of evidence is left when publishing the screen.

 If that is the only thing keeping a Commit instruction from being a feature, perhaps a trail can be added. Whenever you test a query, a log can be created saying user X ran Query: 'XXXXX' at YYYY-MM-DD HH:mm:ss.

I understand the security issue, but hopefully a middle group can be reached where the development team can still manipulate the database without publishing. 



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões

Removing it makes sense for a production environment where you need to leave a trail of evidence that you tampered with data, but for a Dev or Tst environment not having this feature is doing more harm than good, I mean how often you need to delete data from a table because you created a bug? or you created a field that was text but you want to convert it to integer now?
Now we have to create a screen, with a button and a screen action just to fix this, or a timer and run it... 



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões

Now I miss this feature. I think it’s a very useful in lower environments.



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões
Daniël Kuhlmann
mvp_badge
MVP

+1, OutSystems, please make our work more easy not more difficult. 




This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões

+1 for the idea. Good one.



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões
Nuno Rolo
mvp_badge
MVP

Maybe have it only on environments that aren't in production mode.



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões
Nordin Ahdi
mvp_badge
MVP

The Forge has this great component SQL Sandbox created by Leonardo Fernandes, that allows you to execute SQL statements directly on the Platform Database. It even allows you to do so on External Databases.

Check it out if you haven’t already!

Regards,

Nordin



This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões
Changed the category to
Aggregates & Queries


This comment was:
- originally posted on idea 'Allow Developers to commit changes with an Advanced Query, by writing commit.' (created on 05 Dec 2019 by Christian Lopes)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 03 Jul 2020 11:04:00 by Tiago Simões
Justin James
mvp_badge
MVP
Merged this idea with 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 15:32:16 by Sampsa Sohlman)

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,




This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

Hi Sampsa,


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



Regards,

Abílio Matos



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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.



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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.




This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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.



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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.



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Daniël Kuhlmann
mvp_badge
MVP

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..



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Changed the category to
Service Studio


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
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!




This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
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)

This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

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


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

 This merged had no sense, you merged a simple request which was to rollback a feature that was introduced a few months ago  with an idea which is already marked as "Out of the scope" and high complexity. You are basically shutting us up. 



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

Exactly, I have the same thoughts



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Justin James
mvp_badge
MVP

Sorry you feel that way, I have un-merged it. What you DON'T see is that the merge system gives me limited capabilities, including not making it obvious that the target idea was "out of scope". No one was trying to "shut you up". I was trying to make sure your idea got the attention it deserved by rolling in all of the votes. That said, the idea you posted is for nearly the exact same concept as this one, the only difference being that this one wants it to be separate from "test query", and the end goal (being able to do SQL work directly through service studio) is exactly the same. So it was a fairly reasonable merge.

J.Ja



This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Justin James
mvp_badge
MVP
Merged this idea with '[Service Studio] SQL Query Builder' (created on 05 Mar 2020 07:27:32 by Karthik Nataraj)

This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

Hello,

It would be great if there is any SQL Query builder to do CRUD operations on the tables within Service Studio. This will help to insert or manipulate the data during development and testing.

Please let me know if this feature is already available within Service Studio.

Thanks




This comment was:
- originally posted on idea '[Service Studio] SQL Query Builder' (created on 05 Mar 2020 by Karthik Nataraj)
- merged to idea 'SQL Query tool for the Service Studio' on 08 Mar 2020 03:51:44 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Justin James
mvp_badge
MVP
Merged this idea with 'Aggregates - Create, Update, Delete' (created on 10 Aug 2020 18:26:32 by Miguel Oliveira)

This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

For Developing environments, we could be able to update/create/delete the cell information or the complete row in the Aggregates directly. 


This will make the development much faster because sometimes we just need to update or delete some content to continue.



For example, have a toolbar like the image bellow or we could right click and have some options.




This comment was:
- originally posted on idea 'Aggregates - Create, Update, Delete' (created on 10 Aug 2020 by Miguel Oliveira)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:04:04 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

+1



This comment was:
- originally posted on idea 'Aggregates - Create, Update, Delete' (created on 10 Aug 2020 by Miguel Oliveira)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:04:04 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

good idea, this avoids a workaround of sometimes creating extra buttons or screens just for testing purposes if you just want to delete one record. However i feel this should only be available for environments where the administrator explicitly allows it.



This comment was:
- originally posted on idea 'Aggregates - Create, Update, Delete' (created on 10 Aug 2020 by Miguel Oliveira)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:04:04 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Luís Cardoso
mvp_badge
MVP

+1

I think that OutSystems is working already on this. I agree that this should only be available to development environments



This comment was:
- originally posted on idea 'Aggregates - Create, Update, Delete' (created on 10 Aug 2020 by Miguel Oliveira)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:04:04 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Tom Zhao
Champion

+1



This comment was:
- originally posted on idea 'Aggregates - Create, Update, Delete' (created on 10 Aug 2020 by Miguel Oliveira)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:04:04 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Leandro Correa
mvp_badge
MVP

+1



This comment was:
- originally posted on idea 'Aggregates - Create, Update, Delete' (created on 10 Aug 2020 by Miguel Oliveira)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:04:04 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Justin James
mvp_badge
MVP
Merged this idea with 'Database explorer for DEV environment' (created on 10 Jan 2020 08:43:41 by Harlow)

This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

Nice to have if the Outsystems Service Studio has a database server explorer so that it easier to manipulate a record in the database. Maybe this only applicable to DEV/Staging environment. What do you think?



This comment was:
- originally posted on idea 'Database explorer for DEV environment' (created on 10 Jan 2020 by Harlow)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:08:25 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

+1



This comment was:
- originally posted on idea 'Database explorer for DEV environment' (created on 10 Jan 2020 by Harlow)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:08:25 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Justin James
mvp_badge
MVP
Merged this idea with 'Database Management tool' (created on 29 Oct 2019 05:58:53 by Aravind M)

This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

I am expecting in outsystems that the user can interact with their data in the database with a tool or by adding an option to add delete or modify the records in the table will be cool.

Like the image below,

Image result for phpmyadmin



This comment was:
- originally posted on idea 'Database Management tool' (created on 29 Oct 2019 by Aravind M)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:09:08 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

Hi,

I think is a good idea, but, in your view, DB cleaner fills in your requirements?

We have many db utilities in forge that, probably, fills our needs.


But, it's a good idea.


Best regards,

Ricardo Pereira



This comment was:
- originally posted on idea 'Database Management tool' (created on 29 Oct 2019 by Aravind M)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:09:08 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James

Yes, Thanks for your comment.

Instead of forge component or any other external libraries, If we have these functions in our service studio it will be very very helpful.



This comment was:
- originally posted on idea 'Database Management tool' (created on 29 Oct 2019 by Aravind M)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:09:08 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Daniel Marques
Changed the category to
Database


This comment was:
- originally posted on idea 'Database Management tool' (created on 29 Oct 2019 by Aravind M)
- merged to idea 'SQL Query tool for the Service Studio' on 16 Aug 2020 01:09:08 by Justin James


This comment was:
- originally posted on idea 'SQL Query tool for the Service Studio' (created on 20 Nov 2018 by Sampsa Sohlman)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:10:11 by Justin James
Justin James
mvp_badge
MVP
Merged this idea with 'Modify entity data directly on aggregate' (created on 27 Feb 2020 13:29:53 by petergsd)

It would be great if is possible to modify data from an entity directly on the aggregate in DEV environment, something like an excel spreadsheet.

So, there will be not necessary anymore the implemention of a screen with a form and update action just for that purpose.



This comment was:
- originally posted on idea 'Modify entity data directly on aggregate' (created on 27 Feb 2020 by petergsd)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 16 Aug 2020 01:12:20 by Justin James
Justin James
mvp_badge
MVP
Merged this idea with 'Aggregate data clear' (created on 28 Sep 2020 10:26:01 by vijay A)

we  Aggregate table data to truncate or drop table option used for work experience 



This comment was:
- originally posted on idea 'Aggregate data clear' (created on 28 Sep 2020 by vijay A)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 04 Oct 2020 17:20:50 by Justin James
Kurt Vandevelde
mvp_badge
MVP

Hello,

What exactly do you mean? Allowing a drop of a table from service studio is very dangerous as a mistake can not be undone. Same for truncating the table I think.



This comment was:
- originally posted on idea 'Aggregate data clear' (created on 28 Sep 2020 by vijay A)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 04 Oct 2020 17:20:50 by Justin James
Daniël Kuhlmann
mvp_badge
MVP
Merged this idea with 'Provision to update Entity data with SQL Query without publishing module' (created on 04 Oct 2020 12:36:55 by Preeti Kumari)

Hi Team,

As of now, we don't have any provision to update Entity data or execute any database query without publishing Module.

what we have to do now is below steps:

  1. Create an action to call SQL with query/CRUD action of entity
  2. Call the Action form Screen flow
  3. Publish the module
  4. Run application and hit the flow


Problem Statement:

Problem 1:  We are not able to insert/update a record on the fly in OutSystems entities in any environment

Problem 2:  This becomes bottleneck in production environment where we cannot see the data as well, from service studio or anywhere. This is specially required when resolving any production issue.





This comment was:
- originally posted on idea 'Provision to update Entity data with SQL Query without publishing module' (created on 04 Oct 2020 by Preeti Kumari)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 14 Oct 2020 16:12:23 by Daniël Kuhlmann
Daniël Kuhlmann
mvp_badge
MVP

Hi Preeti,

Just do what most of us for install the SQL Sandbox forge component.

Regards,

Daniel



This comment was:
- originally posted on idea 'Provision to update Entity data with SQL Query without publishing module' (created on 04 Oct 2020 by Preeti Kumari)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 14 Oct 2020 16:12:23 by Daniël Kuhlmann

Hi Preeti

The Daniel give a good workaround advise, but use it with caution!


Regards



This comment was:
- originally posted on idea 'Provision to update Entity data with SQL Query without publishing module' (created on 04 Oct 2020 by Preeti Kumari)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 14 Oct 2020 16:12:23 by Daniël Kuhlmann
Daniël Kuhlmann
mvp_badge
MVP

With the NextGen Service Studio presented at NextStep this functionallity will become available, the Data tab no longer only displays data, but you can edit, update and delete as well.



This comment was:
- originally posted on idea 'Provision to update Entity data with SQL Query without publishing module' (created on 04 Oct 2020 by Preeti Kumari)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 14 Oct 2020 16:12:23 by Daniël Kuhlmann
Justin James
mvp_badge
MVP
Merged this idea with 'Create database records in Service Studio' (created on 21 Oct 2020 16:56:29 by Rafael Oliveira)

When creating software from scratch, developers spend a lot of time creating database records in order to performe unit tests. This are big time consuming use cases if the developer does not have excel files to upload data from. 

In order to help developers, Service Studio could have an option to create data in the database, similar to the option that allows update database data that will feature in the new Service Studio.

This would be really helpful in order to accelerate developing time and consequent unit tests, leading to an even faster product delivery.



This comment was:
- originally posted on idea 'Create database records in Service Studio' (created on 21 Oct 2020 by Rafael Oliveira)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 23 Oct 2020 03:35:36 by Justin James
Daniël Kuhlmann
mvp_badge
MVP

Hi Rafael,

In the new nextgen Service Studio you can not only edit data but also add data. 

So I think your idea was already presented on nextstep 2020 as an upcoming feature.

Regards,

Daniel



This comment was:
- originally posted on idea 'Create database records in Service Studio' (created on 21 Oct 2020 by Rafael Oliveira)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 23 Oct 2020 03:35:36 by Justin James
Changed the status to
Working on it
expected delivery in Q1 2021

Hi Marios Tofarides!

We've good news - we're working on your idea! :-)  

As announced at NextStep 2020, in a future version you'll be able to edit your development data inside Service Studio as simply and easily as you'd do it in a spreadsheet.

Thank you and keep your ideas coming. We're listening!

Ângela



Merged this idea with 'Delete Entity Record' (created on 05 Sep 2019 18:00:46 by Rohan Hanumante)

I have came across use case like sometime i wanted to remove one record from the entity which i have created by mistake. To delete that record there should be some kind of functionality on View Entity data screen to delete one or more particular records from the entity.   



This comment was:
- originally posted on idea 'Delete Entity Record' (created on 05 Sep 2019 by Rohan Hanumante)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 07 Dec 2020 12:59:41 by Ângela Dinis
Changed the category to
Aggregates & Queries


This comment was:
- originally posted on idea 'Delete Entity Record' (created on 05 Sep 2019 by Rohan Hanumante)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 07 Dec 2020 12:59:41 by Ângela Dinis
Daniël Kuhlmann
mvp_badge
MVP

With the new edit entity feature that Outsystems is working on this will become available, so I think this idea needs a status update.



This comment was:
- originally posted on idea 'Delete Entity Record' (created on 05 Sep 2019 by Rohan Hanumante)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 07 Dec 2020 12:59:41 by Ângela Dinis
Merged this idea with 'Update table records from the service studio' (created on 19 Jan 2021 19:06:28 by Sherif Diab)

i think it will be a great addition if it is allowed to update the database tables records from the service studio "View Data" action.

as updating the data now requires direct access to the database or updating the data through custom actions.



This comment was:
- originally posted on idea 'Update table records from the service studio' (created on 19 Jan 2021 by Sherif Diab)
- merged to idea 'Edit data directly in ViewData editor inside Service Studio' on 20 Jan 2021 14:45:54 by Ângela Dinis
Changed the status to
Implemented
on 29 Mar 2021

Hello, Marios.

I am very happy to let you know that your idea has been implemented!

From this moment on, editing your entity data is at least 10x faster as you can now quickly add, change and delete your entities data directly in Service Studio under environments with a "non-production" purpose.

You will be able to access this new feature as long as your Service Studio version (download) is connected to a Platform Server version 11.11.1 or above.

We hope we enjoy it. Thank you so much and keep the ideas coming!

Have a nice week,

Ângela.

Thank you, Angela,


I'm really happy about making my idea a reality.


Regards,


Marios

This is really a very good news!!


Regards

I really appreciate that you have taken the time to implement this new feature, it will help a lot.

Thank you for your time.  

I'm really glad this idea got implement, but Service Studio lost one functionality and I created an idea to bring it back: Reimplement drag and drop attribute functionality in aggregate.

This is great news, thank you!

Daniël Kuhlmann
mvp_badge
MVP

Nice, but... even my PE is not yet on Platform Server version 11.11.1 or above. 

The most recent platform version listed is:

Am I missing something... as I don't see there exists a platform version 11.11.1

Great!!

Daniël Kuhlmann,

After your comment 3 weeks ago, Platform Server 11.11.1 is now released (6 April 2021).

Although, Personal Environments (PE) do not have yet available the option to update to 11.11.1, being Version 11.11.0 (Build 26942) the current installed version, at least for me.

We'll have to wait a little bit more time.

--Tiago Bernardo

Daniël Kuhlmann
mvp_badge
MVP

Thanks Tiago, PE are only get updated on major release, so we have to wait for 11.12.0 to be available (somewhere in May 2021).