Sorting records

You may sort the records in the table editor. Sorting does not reorder the records in the table that you are using, it just displays them in the editor in the specified order.

Text fields (String) are sorted alphabetically, numerical fields are sorted by number.

You can sort the records only by one column, either in ascending, or descending order.

 To sort the records in the table editor (ascending or descending order)

  1. Click the grey cell in the type column below the column name, and above the first row with the data. The drop-down menu will appear.
  1. Choose Sort ascending to sort the values in the column in ascending order. You will see the  icon, indicating that the records in the table editor are currently sorted by values in the ascending order.  
  1. Now choose Sort descending to sort the values in the column in descending order. You will see the  icon, indicating that the records in the table editor are currently sorted by values in the descending order.
  1. To return to the unsorted order of the values, you must click the grey cell and deselect the order type that you are currently using in the drop-down menu. The ascending/descending order icon will disappear from the table column cell.