How do we sort(ascending) when using a JDBC request in message mapping?

[Former Member]

Hi Experts,

I need to do a JDBC request in the message mappingI have the following scenario:

Source:

Item

Record

transaction_id

transaction_item

Target:

Statement

table_name

action - hardcoded to 'SELECT'

table - table_name

Access

Field 1

Key

id - mapped to transaction_id

compareOperation hardcoded to 'EQ'

Now, I want to sort in ascending order the statement(target) created by transaction_item. ie transaction_item 1, then transaction_item 2 since I am getting the source values as transaction_item 2 first and then transaction_item 1.

Can anyone please explain how to achieve this?

thanks a lot.

Rewards will be given for sure.

Thanks

Tush

[Former Member]

Hi,

please have a look at the sort function described in this blog:

Regards

Patrick