Example: XML Query With Order By Attributes

See Also

Here is an example of an XML query document with several Order By attributes specified:

<Query>

   <Table Name="PERSON">

       <Column Name="FAMILY_NAME" Condition="Jo%"

           Order-by-seqno="1"

           Order-by-direction="DESCENDING"/>

       <Column name="FIRST_NAME"

           Order-by-seqno ="2"/>

       <Column name="ADDRESS" Condition="%STREET%"/>

   </Table>

</Query>

This results in an XML output document that contains all columns of all records where FAMILY_NAME starts with 'Jo' and ADDRESS contains 'STREET':

<Persons>

   <PERSON ID="377" FAMILY_NAME="Jones" FIRST_NAME="Bill"

       ADDRESS="HIGHSTREET 501"/>

   <PERSON ID="377" FAMILY_NAME="Jones" FIRST_NAME="Patricia"

       ADDRESS="HIGHSTREET 501"/>

   <PERSON ID="312" FAMILY_NAME="Johnson" FIRST_NAME="Ann"

       ADDRESS="ELM STREET 105"/>

</Persons>

The records are sorted in descending order on FAMILY_NAME, and in ascending order on FIRST_NAME, which is only used for the ordering.

This is equivalent to:

INVOKE    XML.EXPORT

WITH

SELECT    *

FROM    PERSON

WHERE     FAMILY_NAME LIKE 'Jo%'

AND    ADDRESS LIKE '%STREET%'

ORDER BY FAMILY_NAME DESC, FIRST_NAME ASC