If an Oracle Commerce record does not include a value for the specified sort key, that record is sorted to the bottom of the list, regardless of the sort order.

For example, the following record set is sorted by P_Year ascending. Note that Record 4 has no P_Year property value.

Record 1 (P_Year 1998)
Record 2 (P_Year 2000)
Record 3 (P_Year 2003)
Record 4 (no P_Year property value)

If the sort order is reversed to P_Year descending, the new result set would appear in the following order:

Record 3 (P_Year 2003)
Record 2 (P_Year 2000)
Record 1 (P_Year 1998)
Record 4 (no P_Year property value)

Record 4, because it has no P_Year property value, will always appear last.