Unique

This option enables you to show only the rows whose combinations of the values of the checked columns are unique. If you turned the Time radio button unchecked while the other radio buttons are left checked, only one of the rows whose data are the same as the data of each other except for the value of the Time column will be shown. Which one will be shown depends on the display order. Only the top row in the display order will be shown. Therefore, the ''Order by'' setting determines which row will be displayed among the rows whose data partially overlaps.

Example 1 Suppose you want to know the number of patients whose diagnosis is tinea unguium. If you shot two or more photos per patient for following up, the number of rows you get when you search with tinea unguium as a key word will be more than the number of such patients. If you execute the same search with the Time radio button of the Unique option unchecked, you will get the number you want because the rows only whose values of the Time column are different will not be shown.

Example 2 Suppose you want a list of every diagnosis you have registered. If you check only the Diagnosis of the Unique option, leave the other columns unchecked and click the Find button while the Search Key entry empty, you will get what you want.