Skip to Content (Press Enter)
Back to Ideas
50
Like
Follow Idea
Best practices
1137Views
3Comments
On our RadarOn our Radar
Documentation


  • If there are any advance queries, replace that by aggregate
  • Don't use foreach Loop in preparation
  • Don't use if conditions in preparation
  • i.e try to avoid if conditions in aggregate
  • Apply pagination on list page
  • Don't show more than 100 records on single page
  • Move JavaScript webblocks to bottom of page
  • Don't use preparation aggregates directly in screen actions
  • Before using them in screen actions refresh them

Suggested by  Suraj.

26 Mar 2018
Copy link to comment
2014-02-07 17-02-43
Vasco Pessanha
Changed the category to
Documentation
26 Mar 2018
Copy link to comment

"If there are any advance queries, replace that by aggregate" Is not best practice:

https://success.outsystems.com/Documentation/Best_Practices/OutSystems_Platform_Best_Practices


Aggregates and Advanced Queries


Queries

  • Use Aggregates: they’re optimized and database independent!
  • Avoid using indexes ([i]) when iterating a Query output
  • Minimize the number of Queries you need to execute
  • Avoid type casts in Aggregates


Advanced Queries

  • Use Advanced Queries only when absolutely necessary
  • Use Parameters instead of hard-coded values in the SQL Indent SQL code consistently
  • Use comments and inline comments in your SQL
  • Use Advanced Queries for bulk operations
  • Do not put business logic in the SQL
  • Use the EncodeSQL built-in function for Inline Parameters
  • Keep in mind that Advanced Queries are database specific


26 Mar 2018
Copy link to comment
Changed the status to
On our RadarOn our radar

Hi Vijay Malviya,

Thank you so much for your idea! 

Let me share with you that we have plans to improve our Best Practices area, in the future. Your suggestions will be taken into consideration.

Keep the feedback coming :)

23 Apr 2018
Copy link to comment