Using Sort - Intergraph Smart Instrumentation - Help

The Sort function is available from the Attributes tab in the Query Builder. Using the Sort commands you can do the following:

• Sort A to Z or from Z to A.

• Decide on the number of characters to be used in the sort

• Decide the order the sort is carried out on the attributes.

For example, a query that has three attributes, Instrument Name, Instrument Location, and Instrument Type. Sorted first by the Instrument Type so it is in alphabetical order from A to Z, and then the Instrument Name is sorted alphabetically to produce a query result where first the Instrument Types are sorted from A to Z and then the Instrument Names of each Instrument Type are also sorted alphabetically.

Sort parameters applied in a query to an attribute's values, that are defined as invisible (Display attribute check box is cleared), are not taken into consideration in the generated EDE. We recommend that if you apply sort parameters to an attribute's values in a query, that the attribute is not defined as invisible. If you do not want to see an attributes values in the EDE report, you can specify which EDE columns to include in the report when printing. For more information, see Print Multi-Header Report from an EDE View.

To use the sort option:

1. Open a query in the Query Builder.

2. Click the Query Attributes tab.

3. On the Attribute you want to apply the sort, click.

4. From the select list select Sort A to Z or Sort Z to A.

   The Sort icon changes to reflect your sort selection, or .

5. To remove the sort reset the select list to None.

6. On the Start spinner, select from which character you want the sort to start. One is the first character of your string, if you want the search to start at the third character of the string, choose three.

7. On the Length spinner, select the length of the string to be included in the sort. The length starts from the character position that you selected with the Start spinner. For example, the string ABCDEFGHI with a start of three and a length of four, then the sort would be carried out on the characters CDEF.

   The Start and Length spinners must be used in-conjunction. Selecting just one of these values results in no sort result.

8. If you want to run the sort on more than one attribute, on the Index spinner choose a number to reflect when you want the sort to be carried out. One being the first, two the second, and so forth.

   If you are only sorting on one attribute there is no need to select an Index number.

9. Click Preview .

   The sort is applied to your query and displayed in the Query Preview tab.

10. When you are satisfied with the results, click Save Query .

    The query is saved and can now be generated as an EDE along your sort settings.