4.3.4 Sorting and Filtering

Almost all the data presented in list format within EPC can be conveniently sorted and filtered. This functionality allows users to organize and access the information according to their preferences.

In this topic, we’ll explore how to sort, filter and even search in the List view, and within sections that contain data lists, like tables present in the System Admin section.

How is EPC data sorted?

The EPC sorting algorithm is alphanumeric, meaning that data will be arranged in a manner that takes into account both alphabetical and numerical order. This ensures a comprehensive sorting approach that considers characters as well as numerical values.

However, there are exceptions for ID and SSN.

• ID is sorted numerically by default. This default sorting for ID involves grouping digit-only values and arranging them in numerical order, followed by sorting them based on character length.
• SSN is also sorted numerically by default. This default sorting for SSN disregards the object prefix and focuses solely on sorting by the numbers following the prefix.
  

However, system administrators have the ability to modify these default settings within the ‘Advanced’ tab. This means that the sorting behavior of these fields can be adjusted according to specific requirements.

Sorting & Filtering in the List Page

Sorting: Click on the desired column header to sort this specific column.

• 1 click will sort in ascending order, reflected by
• 2 clicks will sort in descending order, reflected by
• 3 clicks will remove the sorting action
  

Filtering: You can apply filters by either entering the desired content in the text box of the column header or by accessing the “Filters” option.

• Column Header: The column filters are situated just below the column name, represented by an empty text box and a filter icon.
  
  • If the column you intend to filter contains letters or numbers, you can simply type your desired content into the text box and press ‘Enter’ on your keyboard.
    
  • If the column you intend to filter has predefined options (like “Subtype” and “Type”), select the filter icon. Here, you’ll have the ability to choose the values you want to see and unselect those you don’t want. In this filter menu, you can also search for the specific values you’re looking for.
    
  • If the column you intend to filter represents a simple yes-or-no situation (like the ‘Description’ and ‘Role’ columns), it’s best to utilize the ‘empty’ or ‘not empty’ filters by clicking on the filter icon. As depicted in the image below, selecting ‘empty’ will display objects without a description, while opting for ‘not empty’ will reveal objects with a description.
    
• “Filters” Options: You can find this option on the right-hand side of your screen. When you choose this option, a menu will open.
  
  • Hierarchy Filter: This is the identical hierarchy filter that appears on the List page.
  • The remaining filter options below function in the same manner as described above.
    IMAGE

*Tip: For a more precise search, you can filter multiple columns simultaneously.

To clear filters, simply click on the “clear filters” icon:

Sorting & Filtering in Sections Containing Data Lists

Sorting: Click on a column header to sort this specific column.

• 1 click will sort in ascending order, reflected by
• 2 clicks will sort in descending order, reflected by
• 3 clicks will remove the sorting action
  

Filtering: Type the desired content in the column header text box.