Create Database Views through OutSystems

By Alexei on 5 Dec 2016

It would be great if we could not only create Entities but Views also.

At the Data Tab -> under database make a segregation of Entities (Tables) and Views.

Database

 1. Entities

  2.Views

Provide the same option to make the views public  (YES/NO).

Make it possible to use the views in both query options ( Aggregate / Advanced Query)


Benefit:

This can alleviate a lot of creation of complex queries with a lot of joins in the Aggregate and  Advanced queries. Queries)


Justin James6 Dec 2016

Agreed. The View4Entities component is good, but fills a bit of a different role than this, and you'd still need to add the views back in through an Extension... AND you cant do joins, filtering, etc...

J.Ja