Views that display categories often use sorting methods to alphabetize the category names.

Ascending and descending order

Columns sort documents in ascending or descending order:

• Ascending order sorts in increasing order (where 1 precedes 2, A precedes B, earlier dates precede later dates).

  For example, to display documents from oldest to newest, create a Date column that uses the Creation Date as its value and sorts documents in Ascending order.

• Descending order sorts in decreasing order (where 2 precedes 1, B precedes A, later dates precede earlier dates).

  For example, to display documents from newest to oldest, create a Date column that uses Creation Date as its value and sorts documents in Descending order.

After the ascending or descending order is set, characters are sorted in this order:

• Numbers
• Letters
• Accented letters
• Punctuation/special characters

• Both case-sensitive sorting and accent-sensitive sorting are turned off by default (in previous releases, they were on by default).
• "Case-sensitive sorting" sorts lowercase letters before uppercase letters -- for example, "ab" sorts before "Aa."
• "Accent-sensitive sorting" sorts accented characters after non-accented characters. For example, "ab" sorts before "aa."

If the sort column displays values from a multiple-value list, select "Show multiple values as separate entries" to show each value as a separate row. If you don't set this option, multiple values display as one entry.

Caution If you set this option on a column that displays a multivalue list, but you do not specify a sort order for the column, IBMR LotusR Domino(TM) Designer displays only the first value in the list. Also note that setting this option for multiple columns in a view can have a serious performance impact on your application.

Setting this option correctly on a sorted column may still not produce the results you are expecting. In the following example, Julie has created a document with a field containing the items apples and chickens. Bill has created a document with a field containing the items bananas and ducks. When you sort the Entry column in ascending order and specify "Show multiple values as separate entries," the following view results:

To list multiple entries from a document together, you must sort a column to the left. In this example, sorting the Author column creates the following display:

And finally, to streamline the display, you can categorize the Authors column to produce the following:

Displaying a categorized view as flat

If your view is a categorized view built in Designer Release 5.0 or later, you can select "Categorized is flat version 5 or greater" to convert your view to a non-hierarchical, flat view, which displays all documents on a single level. Use this feature if your level of indentation in a view exceeds the limit of 32 levels.

User-sorted columns

Users see a triangle next to a column title whose values can be resorted. Users click the column and choose a sorting method to see the documents in the order they choose.

To set up a user-sorted column, select the option "Click on column header to sort" on the Sorting tab of the Column Properties box. Then select Ascending or Descending order, or select Both to allow users to cycle among ascending sort order, descending sort order, and no sort order for the column.

Deferred sort index creation

A view in a Domino application may contain more than one index. These additional indices are created for each possible user-sorted column when the view is built. Since most of these sort indices go unused, creating them with the view is an unnecessary load on a server in terms of I/O, CPU usage, and space.

IBMR LotusR NotesR Release 8.0 offers an option to defer the creation of these sort indices until they are needed, by a user clicking on the header of a sortable column. To enable this option for a specific sort index, select the option "Defer index creation until first use" under the "Click on column header to sort" option on the Sorting tab of the Column Properties box.

All on-demand sort indices have a life span subject to the view's discard interval. They can also be explicitly removed by issuing this command on the server console: load updall <dbname> -r -g

Auto-sorted columns

To set up automatic sorting, select the option "Sort: Ascending" or "Sort: Descending" on the Sorting tab of the Column Properties box. The sorting column is usually one that appears on the left side of the view.

Multiple sorting columns

To create multiple levels of sorting, designate more than one column as a sorting column. For example, if a primary sorting column sorts entries by date, a secondary sorting column might sort entries by author. Then all documents created by one person on a particular date are grouped together.

Using an auto-sorted column as the secondary sorting column

To add a secondary sorting column, add a column to the right of the first sorting column and then choose Sort: Ascending or Sort: Descending on the Sorting tab of the Column Properties box. Documents and responses are sorted, then sub-sorted, in column order from left to right.

Designating a secondary sorting column for a user-sorted column

User-sorted columns override the sorting built into auto-sorted primary and secondary columns. If the view has a user-sorted column and you want to include secondary sorting, you can associate it with a secondary sorting column. On the Sorting tab of the Column Properties box for a user-sorted column, click "Secondary sort column" and choose the secondary sort column and its sorting order.

Glossary