Tag Archives: database

OutSystems – Use of comments in Advanced Queries

      No Comments on OutSystems – Use of comments in Advanced Queries

I was creating an advanced query (see post OutSystems – Getting Database Information) for the DBCleaner application to display table space usage. When I executed the query in OutSystems Service Studio using the “Test” button, it gave a (the expected) result, so publish the application an go! Publishing the application went fine, but when I went to the page with… Read more »

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 »