Sort Set Command

By default, 3DSpace presents business objects in sets sorted alphabetically by Type, then Name, then revision. You can disable sorting or specify other “Basic” properties by which objects in sets should be sorted, by using the MX_SET_SORT_KEY environment variable, which can set any number of basic select items (type, name, revision, owner, locker, originated, modified, current, and policy) by which objects in sets will be presented.

For more information, see the Installation Guide.

In addition to this sorting, you can explicitly sort a set by any list of select values in MQL using the following syntax:

sort set SET_NAME [into set SET_NAME] [select VALUE1 VALUE2...];

As with the sorting environment variable, you can specify ascending or descending order by prefixing the select with + or - (ascending (+) is the default.) For example:

sort set x select +name -owner;

This command will perform a sort on both name and owner fields. Names will be sorted in ascending order, then owners will be sorted in descending order.