I have some questions about the database

Import external "Post preSQL" database, you can use "Appregate"?

Hi Chen Yabin,

Yes, if you have the PostgreSQL Connector properly configured in the platform (requires an on-premises scenario), the if you create an extension to map external PostgreSQL Tables onto OutSystems Entities you can use all the standard Aggregate/SQL tool features. The limitation will be you cannot do cross-server joins.

Jorge Martins wrote:

Hi Chen Yabin,

Yes, if you have the PostgreSQL Connector properly configured in the platform (requires an on-premises scenario), the if you create an extension to map external PostgreSQL Tables onto OutSystems Entities you can use all the standard Aggregate/SQL tool features. The limitation will be you cannot do cross-server joins.

Thank you very much

By the way, how do you write if judgment in outsystems SQL? Can you use dynamic SQL?


Hi chen yabin,

OutSystems allows you to query the database using:

  • Aggregate tool, where you can add Calculated Attributes that have in their Formula an If(condition, true-value, false-value) expression.
  • SQL tool, where you write directly SQL (either ANSI SQL or the specific SQL dialect of your database engine - eg. Transact SQL for SQL Server, PL-SQL for Oracle). You can use a standard CASE statement in SQL (check here for a quick review of it).

Hope these help.