INTRODUCTION:
Aggregate is used to fetch data from database. If the Data model had any changes aggregation automatically get that and load the database data from the server. Using aggregate we can perform advance filtering and can combine several entities and can able to get the particular attributes that are used on the screen.
TECHNOLOGY AND TOOLS USED:
The following tools has been used to implement this phone number validation.
- Outsystems-Service Studio.
- Logical Flow.
CREATING AN AGGREGATE:
- To Get the data on the screen, right-click on the screen and select Fetch data from the database.
- An Aggregate open with blank space we need to select our entity there.
- Enter the Entity Nameand select Get Data.
USING AGGREGATE IN ACTION:
To use aggregate we need to add that to the action. For that..,
- Drag the Aggregate from the tool box to the flow.
- Once after you drag and drop the aggregate you may able to see that aggregate along with the entity values under the particular screen get aggregated.
- If the entity name called Fruits the aggregate automatically called
ADDING MORE DATA SOURCE:
- On Opening an Aggregate we may able to see the Source tab, there click Add Source.
- Click on the source we need to add and Click
- We can add our Jointype between two entities.
FILTERING OF DATA:
- We can Filter by Clicking Add Filter.
- After that we can able to see a POPUP box where we can add our filter query.
SORTING OF DATA:
- We can Sort our data by using the Attributes of an entity either in a ascending or descending order.
- Here we used to sort by Name after that click on Select.
- Sorted by descending Order.
CONCLUSION:
Aggregation is a valuable tool in Outsystems for efficiency and analyzing data.It can also improve the performance and user experience of our applications, especially when dealing with large datasets and complex calculations.
