Sort Project Table Panel

Summary

Sort the entries and entry groups in the Project Table by the values of one or more properties. Entries can be grouped before sorting, and groups can be sorted on the same properties as ungrouped entries or on different properties. Entries with the highest or lowest values can be selected after sorting. The sort can be applied to all entries, or just the selected entries.

Opening the Sort Project Table Panel

To open the Sort Project Table panel, you can:

Using the Sort Project Table Panel

This panel allows you to sort entries and entry groups by property values, and select entries after sorting. By default, only sorting by entry is selected.

The default sort order for strings treats sequences of digits as single numbers, so that, for example, ligand10 follows ligand9, rather than ligand1. You can change the order to a standard dictionary order by setting a preference under Project Table – Properties in the Preferences panel.

If you just want to sort the Project Table by values of a single property, you can right-click (or click on the arrow) in the heading of the property column in the Project Table and choose Sort → All Rows or Sort → Selected Rows. You do not need to use this panel for this operation.

To sort entries:

  1. Select a property from the list on the left, and click the right arrow button in the center of the panel.

    The property is added to the Sort entries table.

  2. Click in the Direction column for the property to change the direction of the sort.

  3. To add another property to sort by, select it in the list and click the right arrow button.

  4. To move a property up or down the table, select it and drag it to the new location.

  5. Click Sort Selected or Sort All.

To sort entry groups:

  1. Select Sort groups.

    The controls for sorting groups are displayed below this option.

  2. Choose an option for the properties to sort the groups by.

  3. If you chose to sort by properties of the first entry, select the properties in the list to the left and click the right arrow to transfer them to the list, arrange them and choose the sort order (as described above).

  4. Click Sort Selected or Sort All.

To select the top N entries after sorting:

  1. Select After sorting, select.

    The selection controls for entries are displayed.

  2. Choose the Top option.

  3. Enter the number or percentage of entries to select in the text box.

    The percentage is the percentage of the entries that were sorted.

  4. Choose whether to select a number or percentage of entries, and whether to make this selection in each group or in the entire sorted set of entries, by choosing an item from the option menu.

    The percentage is the percentage of entries that were sorted.

Sort Project Table Panel Features

Property selector

Choose the sort keys from this property selector. You can select a single property from the list to transfer to the Sort entries or the Sort groups table. You can use the tools below the list to restrict the list or to sort it.

Before sorting, group entries option and tools

Select this option to group the entries according to the values of a property before sorting. When you select the option, the Options and Property text box are displayed. Click Options to choose the property and set up the groups.

Options button

Opens the Group by Entry Property dialog box, in which you can select a property and create entry groups.

Property text box

This text box displays the name of the property that was selected to group the entries.

Sort entries option and table

Select this option to sort the entries in the Project Table by the values of one or more properties. Entries within groups are also sorted by these properties, but the order of the groups in the Project Table is not changed.

The table that lists the properties used for sorting is displayed when you select this option. This table lists the properties in the order in which they are used for sorting (as indicated in the first column).

Sort groups, using option and tools

Select this option to reorder the groups in the Project Table. When selected, the options for sorting groups are displayed.

Group title option

Select this option to sort the groups by title.

Properties of first entry, as sorted above option

Select this option to sort the groups by the properties of the first entry in the group, as specified in the Sort entries table: that is, use the same properties for sorting the groups as for sorting the ungrouped entries.

Properties of first entry, as shown below option and table

Select this option to sort the groups by the properties of the first entry in the group, as specified in the table. The table operates in the same way as for sorting entries.

After sorting, select option and tools

Use this option to select entries by number or by property after sorting. There are two options for selecting the entries:

Sort All and Sort Selected buttons

Perform the sort, either on all entries or on the selected entries.

Related Topics


Legal Notice

File: project_facility/sort_project_table.html
Last updated: 30 Apr 2015