The Attribute Sort Options tab allows you to specify one or more attributes by which to sort data output by the export template.
Data is sorted, in the specified Sort Direction, by each attribute in turn in the order in which they are presented in a grid.
A toolbar is shown at the top of the grid, exposing the following options:
•Move Up: this option is enabled when a row other than the first is selected. Invocation moves the row up one position in the grid.
•Move Down: this option is enabled when a row other than the last is selected. Invocation moves the row down one position in the grid.
•Remove: invocation removes the selected row from the grid and is not protected by an ‘Are You Sure?’ dialog.
The grid itself displays a message when empty (‘No sort options have been defined. Drag attributes from the toolbox and drop them onto the grid to add them’). Following these instructions allows you to specify the template’s Attribute Sort Options.
The following columns are shown:
•Order Number
•Attribute - an RPI attribute. Once populated, you can view information about the attribute in the File Information dialog. A validation error is raised if the same attribute is used more than once in the template. You cannot use an exists in table or parameter attribute in this context.
•Sort Direction: a dropdown, exposing values Ascending (the default) and Descending.
You can use anonymous auxiliary database attributes as Attribute Sort Options in an export template resolving to an anonymous auxiliary database. Only database column attributes are supported in this context.