Skip to Content (Press Enter)
UserImage.jpg
chen yabin
39Views
3Comments
I have some questions about the database
Question

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

0
0
28 Feb 2019
Copy Link
2019-09-24 18-41-25
Jorge Martins
 
MVP

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.

0
0
28 Feb 2019
Copy Link
UserImage.jpg
chen yabin

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?


0
0
28 Feb 2019
Copy Link
2019-09-24 18-41-25
Jorge Martins
 
MVP

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.

0
0
03 Mar 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.