How Do I Retrieve Data from an XML Doc in a Preferred Order? (Magic xpa 3.x)

It is important to remember that the XML view simply creates a temporary table in which to store the XML data. Since it is a temporary table, you can add indexes if you wish, and use those indexes as you would for any data source.

Creating an alternate index for an XML view

1. In the Data repository, select the XML view you want to work with.

2. Click on the Indexes tab.

3. Press F4 to create a new index line.

4. Type in a name for your index. Tab to the right.

5. In the Type column, select Non-unique if it is not a unique index.

6. Click on the Segments area (lower left part of the screen). Press F4 to open up a line.

7. Press F5 to zoom to the list of fields. Select the field you want to sort on.

8. Repeat steps 6 and 7 for more index segments, if desired.

Now, when you use your new index in a program, the data will be presented in the order according to that index.

See also

The Online and Rich Client Samples projects (program XM07 and RXM07)