Sorting Records

Individual columns (or a combination of multiple columns) in the grid and Composite View A screen layout in Clooz similar to a grid, but containing a hierarchical structure of expandable groups of rows displayed in a parent-child type arrangement. displays can be sorted in ascending or descending order by clicking on the column header.

Left click on a column header to toggle the sorting between ascending (shows an up arrow in header), descending (shows a down arrow in header), and no sorting (no arrow).

You can designate a more complex sorting by sorting the first column, then hold down the shift key while click one or more additional secondary columns. Numbers will be displayed beside the arrows in the column header signifying the order in which the columns will be sorted. Secondary sorts only matter when there are equal values for records in the preceding sort.

Right-clicking on a column header pops up a menu from which the same sorting can be done (or cleared).

Columns are sorted with an appropriate sorting scheme. Text fields are sorted alphabetically, and numeric fields numerically. In the case of free-form date fields, an attempt is made to extract the year and month. Columns where a mix of data has been combined (as in some of the Composite View columns), are sorted as text.