Refreshed Web Interface > About the Refreshed Web Interface Home Page > About Tables in the Refreshed Web Interface > About Table Operations > Sorting and Filtering the Data
  
Sorting and Filtering the Data
When working with tables in the Refreshed Web Interface, you have options to sort and filter the contents in tables.
Sorting column data
To sort the column data or to remove the sort order, click the column names to sort data in ascending, descending, or no sort order. When a hand icon appears on hovering the cursor over a column name, it indicates that the column data can be sorted.
* 
You cannot sort column data in DocStudio and in the Relationship View.
Filtering column data
To filter rows based on a matching conditions:
1. Click in the column header.
2. Select a condition from the list and type the search text in the filter box. For example, to filter rows that contain the word requirement, select Contains from the list, and enter requirement in the filter box.
The filter is applied.
For information about using column filters in DocStudio, see Considerations for Column Filters and Find Operation in DocStudio
The following table describes the filters available in the filter box:
Filter Type
Field Type
Conditions
Number: For columns that have only numeric values.
• Integer
• Floating Point
• Equals
• Not Equal
• Less Than
• Less Than or Equals
• Greater Than
• Greater Than or Equals
Date: For date columns.
Date
• Equals
• Not Equal
Text: For columns that include both numbers and text as values.
All field types, except Integer, Floating Point, and Date.
• Contains
• Not Contains
• Equals
• Not Equal
• Starts With
• Ends With
* 
• You can apply the column filters on the loaded data for all the columns. The filtered data matches the conditions applied in the filter. You can reset the conditions by clicking Reset in filter box.
• You can apply the column filters on multiple columns.
Autosizing, pinning, and changing column location
1. To change the column size.
2. To show or hide the columns.
3. To pin columns.
Icon/Action
Operation
: Autosize
Click and select Autosize This Column or Autosize All Columns to change the size of the selected column or size of all columns respectively.
: Show or Hide
Click to show or hide columns in the Content pane.
Change column location
To move a column, select a column header, press the left mouse button, and drag the column to the desired location.
: Pin columns
Click and select Pin Column to pin the selected columns to the left or the right
PTC recommends that you do not pin more than 4 columns. If the pinned columns have large column width, you will not be able to access the other columns in the content pane.