How do we directly edit database?
Question

Is it possible to directly edit my database without bootstrapping data or creating a form to manually filling up the data?

mvp_badge
MVP

Hi Tamie,

If you have direct access to the DB (your OutSystems installation is on-premises) then yes. Otherwise, although there are ways around it, there seems to be an effort from the OutSystems product itself to restrict that and guarantee that all DB manipulations go through OutSystems applications.

Can you explain your need? We might be able to better advise on the recommended way to address it (or explore other available options).

Hope this helps!

Jorge Martins wrote:

Hi Tamie,

If you have direct access to the DB (your OutSystems installation is on-premises) then yes. Otherwise, although there are ways around it, there seems to be an effort from the OutSystems product itself to restrict that and guarantee that all DB manipulations go through OutSystems applications.

Can you explain your need? We might be able to better advise on the recommended way to address it (or explore other available options).

Hope this helps!

Hi Jorge,

No, I do not have Outsystems on-premises. 

As I am still in the early stages of development and adding new features to my app, there are times where I have to add new attributes to existing entities with records in the DB. Because of this, I have to edit every record in my DB to include a new feature. 

Currently, I am using a Timer (Schedule: When Published) and server action. I filter the records then use For Each to delete or edit records. I am not sure if this is best practice. Perhaps there is another around this? Thanks!

mvp_badge
MVP

Hi Tamie,

If you are familiar with SQL than use the SQL Sandbox application available in the Forge.

Regards,

Daniel

Champion

Daniël Kuhlmann wrote:

Hi Tamie,

If you are familiar with SQL than use the SQL Sandbox application available in the Forge.

Regards,

Daniel

Thanks for this Daniel

I wasn't aware this existed on forge and will save me time next time I want to do more advanced things in SQL.

Daniël Kuhlmann wrote:

Hi Tamie,

If you are familiar with SQL than use the SQL Sandbox application available in the Forge.

Regards,

Daniel

I am not familiar with SQL, so I will not be trying this out for now. But thank you for this tip! I will try it in the later stages of my development.


mvp_badge
MVP

Tamie Wong wrote:

Daniël Kuhlmann wrote:

Hi Tamie,

If you are familiar with SQL then use the SQL Sandbox application available in the Forge.

Regards,

Daniel

I am not familiar with SQL, so I will not be trying this out for now. But thank you for this tip! I will try it in the later stages of my development.


Hi Tamie,

That is perfectly fine. I do want to point out that gaining some basic knowledge of SQL will make your life as an (OutSystems) developer easier. There is a great free learning site that makes learning fun that has a SQL Fundamentals course.

Regards,

Daniel

Hi, Tamie.

I am reviving this forum post to tell you that since Service Studio version 11.10.16 editing your data is at least 10x faster! You don't need to jump into SQL or create a form/full back-office anymore. You can now quickly add, change and delete your entities data directly in Service Studio under environments with a "non-production" purpose. 

Let us know what you think! :-) 

Have a nice weekend,

Ângela

Angela that is not enough, you must upgrade the Environment version.


Regards

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.