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

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:

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:

Hope that this helps you.

Kind regards,

Rui Barradas