Sort Data Table

From PresenceWiki
Revision as of 15:01, 22 June 2010 by Admin (Talk | contribs)

(diff) ←Older revision | view current revision (diff) | Newer revision→ (diff)
Jump to: navigation, search

The Sort Data Table node reorders the rows in the current Data Table in ascending or descending order of the values of the columns contained. Below is the dialog box that is presented when dragging a Sort Data Table Node into your Task:

http://www.international-presence.com/wikidocs/images/sort_table_dialog.png

Sort Priority

In order to add a Column for consideration, drag it from the list of available columns on the left into the table on the right. Columns with a higher priority (at the top of the table) will be used first for sorting the table. If values are equal the next column will be considered, and if those values are also equal the third column will be considered - and so on.

For example, consider the following Table, before and after sorting on the AGE and SURNAME columns (in that order):

FORENAME SURNAME AGE
Adrian Smith 37
Mark Townsend 34
Susan Jerone 33
Lisa Coultier 34
Albert Petersson 37


FORENAME SURNAME AGE
Susan Jerone 33
Lisa Coultier 34
Mark Townsend 34
Albert Petersson 37
Adrian Smith 37

As you can see the second column (SURNAME) is only considered if the first column (AGE) is identical.