15
 Followers
46
 Likes

Edit data directly in ViewData editor inside Service Studio

Backend
New

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

Created on 6 Sep 2018
Comments (15)

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)

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
views
650
Followers
15