Filtering and Sorting

Filtering data means that only data that meets a certain criterion is shown, for example, that it was made on the same day or for the same customer.

Sorting determines how the data in the database should be sorted, e.g., by ascending order number, by date, by subscriber name, etc.).

The best way to illustrate how they work is to look at the table below, which contains the orders and their details.

1. Sorting

If we sort the orders by customer, the table will be displayed as follows:

With sorting, we have achieved that the layout of the records ascends by subscriber name, not by record number.

If we select sorting by order number again, the layout will be the same as before sorting.

2. Filtering

Filtering has a similar function, as it changes the view of the database, but it only shows part of the database. So, for example, filtering by subscriber “A” will show us the following records:

Filtering by referent “B”:

With a little thought and the use of filtering and sorting, seemingly complex tasks can be done quickly and easily.