Sort function sorts a data source by a given rule.

The input is a data source and a field indicates the rule to sort by. The output is the sorted version of the input data source.

 

The following example displays the concatenated values of first-name and last-name sorted in ascending order by first-name.

 

 

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>

<das:job xmlns:das="http://www.ecrion.com/das/1.0" last-id="95">

       <das:output id="1">

               <das:element id="2" name="root">

                       <das:element-sequence id="76" name="element-name" data-source="64">

                               <das:attribute id="92" name="full-name" value="83"/>

                       </das:element-sequence>

               </das:element>

       </das:output>

       <dia:diagram xmlns:dia="http://www.ecrion.com/dia/1.0">

               <dia:connection id="66" src="6" dest="64:datasource"/>

               <dia:connection id="67" src="7" dest="64:filter"/>

               <dia:connection id="77" src="64" dest="76"/>

               <dia:connection id="87" src="7" dest="85"/>

               <dia:connection id="88" src="9" dest="86"/>

               <dia:connection id="91" src="90" dest="84"/>

               <dia:connection id="93" src="83" dest="92"/>

               <dia:connection id="94" src="1" dest="64:filter"/>

               <dia:connection id="95" src="5" dest="64:filter"/>

               <dia:diagram-output id="1" x="638.000" y="340.000" width="196.000" height="164.000"/>

               <dia:diagram-table-data-source id="6" x="96.000" y="344.000" width="200.000" height="100.000"/>

               <dia:diagram-sort-function id="64" x="366.000" y="241.000" width="200.000" height="100.000"/>

               <dia:diagram-function id="82" x="406.000" y="534.000" width="200.000" height="100.000"/>

               <dia:diagram-const-function id="89" x="164.000" y="554.000" width="150.000" height="80.000"/>

       </dia:diagram>

       <das:concat-function id="82">

               <das:in-param id="85" name="string" src="7"/>

               <das:in-param id="84" name="string" src="90"/>

               <das:in-param id="86" name="string" src="9"/>

               <das:return-value id="83"/>

       </das:concat-function>

       <das:const-function id="89">

               <das:const-return-value id="90" value=" " type="string"/>

       </das:const-function>

       <das:table-data-source id="6" name="Emp" connection="5">

               <das:field id="7" name="FIRST_NAME"/>

               <das:field id="8" name="ID"/>

               <das:field id="9" name="LAST_NAME"/>

       </das:table-data-source>

       <das:sort-function id="64" data-source="6" filter="7"/>

       <das:database-connections>

               <das:database-connection id="5" name="Sample DB"/>

       </das:database-connections>

</das:job>

 

 

 

Attributes:

id - unique identifier of this resource in the current processing job.

data-source - input data source.

filter - filter used.

 

Note. This sample can be found in Samples\Job Samples folder.