Tag Archives: entity

OutSystems – Getting Database Information

      No Comments on OutSystems – Getting Database Information

In this post I will provide some queries that you can use to get information on the OutSystems schemas in an Oracle database.   List inactive (unused) entity tables It is pretty simple to get a list of all inactive entity (unused – the entity got removed from OutSystems) database tables. SELECT esp.name ESPACE, ent.name ENTITY, ent.physical_table_name TABLE_NAME FROM osadmin.ossys_espace… Read more »

OutSystems – Adding/Changing/Deleting Entities and Entity Attributes – Database Implications

Running into an “Database Upgrade Error” on publishing and application after I changed the length of an existing entity attribute, gave me some insight into how the OutSystems platform handles changes on entities and entity attributes. In this post I want to give an overview of the¬†implications on the database used by OutSystems, whenever you work (add, change, delete) with… Read more »

OutSystems platform using Oracle Database – VARCHAR2 to CLOB

When I was developing an application in OutSystems, I changed the size of one of the “Text” entity attributes of one of my entities from 500 to 5000. Service Studio just let me do this and there were no errors or warnings in TrueChange. Then I clicked the publish button:¬†Database Upgrade Error Different Oracle data types used for OutSystems “Text”… Read more »