Input and Output Parameters for preparation and screen action?

Hello All,


what inputs and outputs can be used in preparation and screen action.

advantages or disadvantages of sql queries and aggregates.


Kindly help me with the answer.

U shoul use sql queries for a lot of reasons but I think the main reason is the performance.


There is some documentation about that. Take a look.

https://success.outsystems.com/Documentation/Best_Practices/Performance_Best_Practices/Performance_Best_Practices_-_Queries#Use_SQL_queries_for_bulk_operations


Best Regards.

Hi Singanamala,


Aggregates have advantages in the common cases (the platform can optimize the code for you), but you have many things that you can't do with aggregates or, at performance level, it's not the best way. In that cases, you need SQL Advance. One of that cases is when you want to do a bulk operation (update all p.e.). It's much more efficient SQL advanced than make the for each with an aggregate.

You can see this video (it's long but it's very good) to help you understand better the reasons and the best practices for this cases: https://www.outsystems.com/learn/lesson/1133/master-class-on-best-practices-and-timers/


Hope this can help you.


Best regards,

Ricardo

Hi,

Question 1: what inputs and outputs can be used in preparation and screen action.

Go into a screen and try to add an Input parameter, you can find out for yourself what are the possible data types.


Question 2: advantages or disadvantages of sql queries and aggregates.

It is easy to googleyourself on this and find several useful links that give you some insights:

https://medium.com/@jmjames/aggregates-or-advanced-sql-when-to-use-which-one-8f052c0de324

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

https://itnext.io/outsystems-101-aggregates-vs-sql-queries-ec7223f4c496

https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Aggregate_a_Column_into_a_Single_Value


Regards,

Daniel


Thank you Everyone