After you create entities to persist data, you can edit your app's data without leaving Service Studio.
Add, remove, and change records of entities during app development, enables you to do the following:
Test your app with real and meaningful data to ensure your apps works correctly once it reaches your production environment.
Prepare your demos with the right data to show your stakeholders real use cases and enable them to give you meaningful feedback.
To edit entity's data in Service Studio, ensure the following:
You're connected to an environment that uses Platform Server release 11.11.1 or later.
You're connected to an environment with Purpose set as Development or Non-Production.
Your IT user has Change and Deploy Applications or higher for the module that contains the entity you are editing.
If your environment uses Multiple Database Catalogs and Schemas, the entity must belong to a module published to the (Main) database catalog.
Entities whose data can be edited
In Service Studio, you can edit the data of entities that meet the following criteria:
- The entity has an Identifier attribute.
- The entity is a server entity. You can't edit the data of a client entity.
- If the entity is Multi-Tenant, the Show Tenant Identifier property must be set as False, which is the default value.
- The entity isn't an exposed process entity.
To start editing an entity's data, open the module where the entity exists. Then in the Data tab, double-click the entity, or right-click the entity and select View or Edit Data.
Even thought it seems like you're editing data in a spreadsheet, you're actually preparing changes to data in a relational database.
Rows represent entity records, and cells represent attributes.
In the entity Data screen, you can then add rows, remove rows, and modify cells of existing rows to the entity. Changes aren't committed immediately, you can prepare several changes before applying them.
Service Studio adds an asterisk, *, to the first cell of rows that contain pending changes.
If the change applies to specific cells of a row, Service Studio highlights that cell's background.
Service Studio continually validates your pending changes, and highlights cells with a red outline if it detects an issue.
Check the issue by hovering over the highlighted cell. Fix these issues before applying your changes.
If needed, you can discard your changes all at once, or one row at time.
Once you apply your changes, Service Studio creates and sends SQL statements to your platform database, changing one record at a time.
After trying to apply all your changes in the database, Service Studio lets you know if all changes were successful, or if any of the changes failed.
If you don't apply or discard your pending changes, Service Studio keeps them saved in your machine.
Articles in this Section
- How to edit the data of an entity in Service Studio
- Learn how to add a record or row, remove a record or row, and change an attribute or cell in Service Studio.