Sorting/Filtering Data

Sorting

 

Click on the column headings to sort the data. Click again on the same heading to reverse the sort order.

 

Filtering

 

Text boxes beneath the column headings allow you to filter the data: the table is automatically updated to display the products matching the entered criteria.

 

The entered criteria are cumulative, since the filters use a common AND logical function. Therefore, if you enter “mouse” in the product field and “Microsoft” in the manufacturer field, the table will only display those mice made by Microsoft.

 

You may enter numeric criteria based on price, for example:

 

  • 100: Displays all products with a price of € 100;
  • >100: Displays all products with a price greater than € 100;
  • <=100: Displays all products with a price lesser than or equal to € 100;
  • 100..200: Displays all products with a price greater than € 100 and lesser than € 200.

 

Certain columns have a dropdown list containing all the values available for the displayed list of products.