12
Views
1
Comments
can a user apply filter to data like we do in MS excel
Question

can a user apply filter to data like we do in MS excel

Rank: #157

Hello Amitabh,


Yes, OutSystems allows to apply filters to data.

You can either use SQL Queries or Aggregates to fetch data from the database. Using both of them, you will be able to apply filters to get the results that you want. When designing queries, it is common to add some conditions to filter results and get exactly what you pretend from the database.

Please, check this documentation:
https://success.outsystems.com/Documentation/11/Developing_an_Application/Use_Data/Query_Data/Filter_Query_Results 


Also, you have System Actions like ListDistinct (filters duplicate elements from a list) or ListFilter (returns a new list with the elements from the List parameter satisfying the given condition) that may help you to filter data.

You can also check this documentation with the available actions:
https://success.outsystems.com/Documentation/11/Reference/OutSystems_APIs/System_Actions 


Hope that this helps you.


Kind regards,

Rui Barradas