Reporting > Native reporting system > Reporting system command language > ORDERBY command > KEYLENGTH
  
KEYLENGTH
KEYLENGTH is an optional subcommand that can be used with the ORDERBY command to specify the length of the field to be sorted.
The numeric value assigned to KEYLENGTH is equal to the number of characters to be included in the sort.
Example
ORDERBY Name KEYLENGTH 20, Type KEYLENGTH 5
This example sorts first by the name then by type of the object. Only the first 20 characters of the name are examined for sorting. Similarly, only the first five characters of the type are sorted. However, Data Flow Gane & Sarson and Data Flow Ward & Mellor diagrams are sorted as if they were the same type of diagram, being sorted only by the diagrams name, since the type does not differ until the eleventh character.