Difference between aggregate and SQL

Difference between aggregate and SQL

  

What are the differences between Aggregate and SQL?

The issue used Aggregate can be changed to the SQL?Or the issue used SQL can be changed to the Aggregate?Or Aggregate and SQL cant be exchanged?

Aggregate is optimised by platform, but the SQL is optimised by what? 

Hi yanyi,

Please take a look at the article below, I think it answers all your questions.

https://itnext.io/outsystems-101-aggregates-vs-sql-queries-ec7223f4c496?gi=30b00bf72b6d

Best Regards, 

Ruben Meireles wrote:

Hi yanyi,

Please take a look at the article below, I think it answers all your questions.

https://itnext.io/outsystems-101-aggregates-vs-sql-queries-ec7223f4c496?gi=30b00bf72b6d

Best Regards, 

Thank you very much!

But I cant open the URL.

Does the article have another method for accessing the article?

Waitting for you.


Solution

That is strange... you can simply go on Medium (https://medium.com/) and search for "Aggregates vs SQL Queries" and you will find the article. 

You should also take a look at the outsystems video relating to Data Queries:

https://www.youtube.com/watch?v=kz4o-PcJhtU

Best Regards,


Solution

Ruben Meireles wrote:

That is strange... you can simply go on Medium (https://medium.com/) and search for "Aggregates vs SQL Queries" and you will find the article. 

You should also take a look at the outsystems video relating to Data Queries:

https://www.youtube.com/watch?v=kz4o-PcJhtU

Best Regards,



Thank you very much!

Hello yanyi wang

I would say that the best approach for learning about OutSystems is to take the Online training first.
In the Online training you will see the differences between the aggregates and SQL. But it is done in an structured way and at the end of the training you will be able to apply your knowledge to build OutSystems applications in a much more efficient way than trying to learn it "messing around".

https://www.outsystems.com/learn/paths/2/becoming-a-web-developer/

https://www.outsystems.com/learn/paths/1/becoming-a-mobile-developer/

The link below talks about the Aggregates and SQL.

https://www.outsystems.com/learn/lesson/858/data-queries/

Cheers.