Sort formula format

[Former Member]

Hi,

I need help on system action "Sort rows". What format the field "sort formula" has?

Edited by: Eugene Balakhonov on Apr 15, 2008 3:17 PM

[Former Member · Accepted solution]

Hi,

the formula is of type string, and it represents the sorting order.

the expression is a string expression that is evaluated against each object in turn and returns the string value the defines the position of the object in the sorting order.

after passing on all the dataset's objects the infoset cursor points on the first object in the newly sorted infoset.

so far the technical stuff..

for example:

for objects:

FIRST_NAME | LAST_NAME

1 Kenny Smith

2 John Smith

3 George Bush

SORT(@LAST_NAME & "," & @FIRST_NAME)

this will sort all the object in lexicographic order, i.e. Smith, John before Smith, Kenny and After Bush, George.

Regards,